Questions tagged [migration]

the process of moving databases or data from one place to another

Filter by
Sorted by
Tagged with
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 ...

1
2 3 4 5
19