Questions tagged [migration]
the process of moving databases or data from one place to another
916
questions
0
votes
2
answers
18
views
Regarding creating the index
there are two db we migrated the data from db1 to db2 now the db2 have some indexes missing in it and we need to create all those index in db 2 but we only have the indexes name nothing else is known
...
5
votes
3
answers
739
views
Moving a database to a new server
My database server is being decommissioned at work. We have a new database server to take its place. Both servers have the same operating system and SQL Server 2008. I need to move all my databases ...
0
votes
1
answer
748
views
How to "clone" entire MS SQL base to another host?
I'm rather new to MSSQL and maybe a task is very simple.
I have WinServer 2016 and SQL Server 2016. I need to copy/clone/migrate everything about SQL server (logins, procedures, schedules, tables...) ...
2
votes
1
answer
1k
views
Have to regenerate SQL Server Master Key after every server reboot
We recently migrated our database over from SQL Server 2012 to a new SQL Server 2019 box. As soon as the database was migrated, I regenerated the master key, but whenever our SQL Server 2019 box ...
1
vote
1
answer
353
views
Moving from MySQL 5.7 to MySQL 8.0
I'm currently running MySQL 5.7 in one of the key servers. This version reaches end of life soon, so it's time to move to 8.0. Or give it a shot and jump on 8.1?
This one is also running on dated ...
0
votes
1
answer
8k
views
Error Calling Python module function DbMySQLFE.connect
Migrating a database from SqlServer to Mysql using "MySQL WorkBench 6.3 CE" using ODBC data source as default methode to use to connect to the RDBMS.
-> Source Selection Test connection is Successful ...
8
votes
2
answers
8k
views
Physically migrate MySQL without a dump
A client ask me to migrate his MySQL DB:
The server doesn't have free space and it also has a very big table that is broken, so I can't dump it.
I can't REPAIR it because of lacking of free space.
...
0
votes
1
answer
466
views
mysql database migration of schemas with updated data and structures
I am a newbie with MySQL database dumps and am currently trying to work with data migration between a source schema and a target schema.
Assuming the source schema is defined by (...
0
votes
1
answer
81
views
Encountering an Issue with Oracle ORA-39405 Error
I've been researching and testing for days now, and so far, I haven't been able to solve my problem. I'd like to know if any of you have ever encountered this.
I'm facing a challenge with a client's ...
20
votes
6
answers
196k
views
How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8?
I was given the task to migrate a PostgreSQL 8.2.x database to another server. To do this I'm using the pgAdmin 1.12.2 (on Ubuntu 11.04 by the way) and using the Backup and Restore using the custom/...
3
votes
1
answer
877
views
How to install Distributed Replay (dreplay.exe) for SQL Server 2017
In SQL Server 2014, dreplay.exe was available under "Management Tools – Basic" feature. However, in SQL Server 2017 that feature no longer exists (Enterprise edition) and it doesn't come with SSMS ...
1
vote
2
answers
80
views
SQL Developer edtion as a new node within an Enterprise Availability Group
We currently have a 2 node Availability Group in our test environment running SQL Server 2017 Enterprise Edition.
I need to downgrade these both to Developer edition, since we are not using this in a ...
0
votes
1
answer
308
views
Issues regarding phpMyAdmin - character set
I'm trying to migrate a Wordpress site from one server to another. Everything is going fine apart from the database migration.
I have my database 'A', and using phpMyAdmin I am attempting to export ...
0
votes
0
answers
17
views
Loops not allowed on MongoDB Relational Migrator
Hi I'm trying to use MongoDB Relational Migrator to migrate my postgreSQL DB to MongoDB but I'm getting this message when I try to create a data migration job
Error building job context: loops not ...
0
votes
2
answers
2k
views
Cloning the database to another server with raw data files
I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
0
votes
1
answer
538
views
Why could pgloader fail with 'undocumented reason' while migrating large MySQL database to PostgreSQL?
The database I would like to import is approximately 55GB in binary format, about 36 GB exported by mysqldump. But as we know even the postgres compatible mysqldump is not 100% compatible, so I'm ...
0
votes
0
answers
12
views
How to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC?
What are the different ways to migrate from Oracle 11g Single Instance residing on a Azure Linux VM to Oracle 19c RAC on Azure VMs?
1
vote
1
answer
1k
views
What does MISSING_TARGET means on Amazon DMS (Database Migration Service) validation?
I'm running Amazon DMS from RDS to Aurora, the error when full restarting (never been successful before) from awsdms_validation_failures_v1 tables are:
[
{
"TASK_NAME": "...
0
votes
1
answer
36
views
MariaDB to MySQL migration using AWS DMS
I have a master-slave mariadb 10.3.29 running on AWS EC2 and needs to be migrated to AWS Aurora MySQL using DMS. In order to do that i need to change the binlog_format to ROW(both master and slave) ...
0
votes
1
answer
370
views
How to conditionally recreate indexes created by `CREATE INDEX ON <table_name> (<column_name>)`?
I am squashing migrations and rewriting all constructs like:
CREATE TABLE entities (
id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
title text NOT NULL,
description text
);
CREATE INDEX ON ...
0
votes
0
answers
29
views
SQL Server database migration issues
I have a system with two servers and three client workstations. Servers were configured to work as principal/mirror servers (mirroring was configured with certificates). I have two databases in SQL ...
0
votes
1
answer
363
views
SSRS 2008 to 2014 Migration Excel Export error
We are working on migrating our SSRS from SQL Server 2008 to SQL Server 2014. After brining the reports over I have a set of reports that will execute just fine but when I try to perform a standard ...
0
votes
0
answers
21
views
How to migrate a web app from a monolithic to a backend-frontend architecture while keeping both running side-by-side? (PHP, MySQL)
I have been maintaining for quite some time a monolithic web app written in vanilla PHP, SQL, CSS, and JS (no frameworks used; no external APIs used; in simple terms, it's just PHP code querying a ...
0
votes
1
answer
2k
views
how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON
how to replace dbms_reputil.from_remote in oracle 12.2.0.1 since All objects removed except REPLICATION_IS_ON, _OFF and _ON
0
votes
1
answer
53
views
Live database migration MariaDB 10.5 to MySQL 8.0
I need to move a busy OLTP database from self hosted MariaDB 10.5 to Google Cloud SQL for MySQL 8.0 with minimal downtime.
The source is a self managed VM instance in Googles Cloud with replicas, ...
0
votes
2
answers
644
views
Side By Side Upgrade and Migration from 2008 to 2016
Side By Side Upgrade and Migration from 2008 to 2016
Old Server Name Test1
New Server Name Test1
Default Instance Test 1
My question is when the new server be named as the old one 'Test1" and it ...
24
votes
3
answers
61k
views
Change existing column in PG to auto-incremental primary key
I have a database in Postgresql, which was migrated from SQL Server (only data).
On SQL Server, a table from this database has these columns:
measure_id
datum
measure
where measure_id is auto-...
5
votes
1
answer
3k
views
Migration from DB2 to MySQL
Does any one have experience on migration from DB2 to MySQL ?
Please share with me.
I tried googling, but I have not received much information on this.
0
votes
1
answer
709
views
MySQL: carriage-return in query breaks my import
I use simple echo "select * from tab" | mysql --batch --quick --skip-column-names .... > /tmp/file from mysql to get data.
Then, import to postgres using \copy tab FROM /tmp/file ...
0
votes
1
answer
561
views
MySQL DB Migration from on-premises to AWS through replication
I am having a production MySQL server with set of 20 databases in on-premises server. Now I require to migrate few databases from production server to AWS RDS without disturbing other databases in one-...
2
votes
1
answer
630
views
Missing Oracle Schema in SSMA Object Explorer
We are currently working on a project to move all of our disparate DBs (MySQL, Oracle, older versions of MS SQL) to SQL Server 2014. So far, pretty much everything has gone smoothly, however, there is ...
0
votes
1
answer
3k
views
How to handle logins and database users for migration of sql server into new domain (new installation, no trust with original domain)?
I want to migrate SQL server 2016 to SQL server 2019 (both machines are onprem, separate domain, no trust/connectivity between the domains, the new sql server will be a new installation on target ...
1
vote
1
answer
353
views
For migrations without downtime, are default values or nullable columns always required?
Here is an example:
You create a new column called note on the payments table on v1.1.0 (green) of your application. However, you notice a bug. You roll your application back to v1.0.0 (blue). When v1....
2
votes
1
answer
525
views
Migrate Postgres from VM to VM
I have 2 VMs, both are identical in structural terms (came from the same snapshot, nothing installed, upgraded or removed).
One VM is "clean", never used.
The other VMs was heavily used and it has ...
2
votes
1
answer
950
views
Query from Postgres to SQL Server
I have this query in PostgreSQL and I am not familiar with PostgreSQL. I need to convert it to SQL Server.
SELECT (applicant_majors.*)::applicant_majors
FROM applicant_majors
WHERE applicant_majors....
0
votes
0
answers
38
views
How can I make a foreign-key case-insensitive in Postgresql?
I have a Mariab-database using collation utf8bm4_general_ci and I am migrating to Postgresql.
Some tables are foreign keyed using case-insensitive strings (e-mails sourced from different systems).
...
0
votes
2
answers
840
views
Migrate from SQL Server 2014 Failover Cluster to 2019 Availability Group, rollback plan
we have a 2 node SQL Server 2014 failover cluster with 2 SQL Server instances and about 100 databases to be migrated to an availability Group 2019. What is the faster way to do that considering that ...
0
votes
0
answers
58
views
Pgadmin4: Export/decrypt saved Passwords
Since we are migrating pgadmin from sqlite to a postgres Database, one of my main problems right now is to export the stored servers with their saved passwords.
The passwords are encrypted using the ...
0
votes
1
answer
588
views
Regular data transfer from SQL Server to MySQL
Our company uses an application with a SQL Server database where we store all of our Project Item data.
Our company's Portal Website uses a MySQL database that holds other Project information (...
2
votes
1
answer
182
views
DB migration - Converting Unique constraint to Primary key
I have a a table which has unique index:
CREATE UNIQUE INDEX IF NOT EXISTS tb_sha256_key_idx ON blob_props (sha256, key);
I want to change it into primary key during db migration and there are 2 ways:...
0
votes
3
answers
6k
views
What is Fastest way to shrink a datafile?
I have a 4 Tb SQL Server 2008 R2 database. I'm going to move this DB to a new server with a new release of SQL Server 2012. (the application does not support SQL Server > 2012, but that is not the ...
0
votes
1
answer
418
views
How to daily copy selected data from MySQL and PostgreSQL servers to another PostgreSQL server
I have two source servers, a MySQL 5.7 and a PostgreSQL 9.6, respectively. I would like to daily update some tables from each source to another target PostgreSQL 11 server (via a cron-job).
On the ...
1
vote
1
answer
709
views
Transition from MongoDB Time Series Collections to InfluxDB
With version 5.0 MongoDB's specialized Time Series Collections were introduced to deal with such data. As I already stored some sensor meta data (configuration, specification ...) in MongoDB, I ...
0
votes
3
answers
1k
views
Move large mysql table data from one server to another
I have a table to which millions of data are inserted every day. As the table size grows more than 10 GB, I have issues with the performance of server in fetching apis and generating reports, which ...
0
votes
1
answer
317
views
SSRS migration with Same Name and Moving of Reporting Files
This is will be my first SSRS migration and please bear with me if some points don’t make any sense.
I need to migrate the Reporting server but need to keep the same name so that the reporting URL don’...
3
votes
1
answer
7k
views
Is there any way to pg_upgrade PostgreSQL 12 to 15 over network?
My situation is a little bit complicated.
I have an older version of PostgreSQL 12.9 installed on an older Centos Stream 8 machine. There are about five custom databases created under the roof, say ...
1
vote
2
answers
108
views
Migrating from PostgreSQL to MySQL (data with \r\n)
I'm trying to migrate a database from PostgreSQL to MySQL on an Ubuntu 23.04 system (latest version of both).
So far, it looks like things are fine, except for one problem. In one of the character ...
0
votes
1
answer
354
views
Whether to migrate database or logins first?
In a SQL server 2012 to SQL server 2019 migration, is it recommended to migrate the databases first or the logins first?
1
vote
1
answer
480
views
New SQL Server 2022 slower than old 2014 server
I'm planning and testing a new SQL Server 2022 install to migrate from an older 2014 database. I've noticed during performance testing some major discrepancies with some bulky queries.
Here is a query ...
0
votes
1
answer
1k
views
Problems during migration from SQL Server to MySQL via MySQL Workbench
We've found most of the options we needed to include the necessary CHARSET. Here is what we've included in the MySQL my.cnf:
[client]
default-character-set = utf8mb4
[mysql]
default-character-set ...