Questions tagged [migration]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
15 views

Configuring Informix to access data on another server

I have inherited an Informix installation that contains a large amount of business logic in the form of procedures. The company also uses SQL Server, MySQL and Postgres for various roles. We're very ...
Hut8's user avatar
  • 101
0 votes
1 answer
114 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 ...
Thiago Roque's user avatar
0 votes
0 answers
18 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 ...
user2782149's user avatar
1 vote
2 answers
88 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 ...
user3346030's user avatar
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?
Sunil Bopanna's user avatar
0 votes
1 answer
38 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) ...
JollyRoger's user avatar
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 ...
Lamija37's user avatar
0 votes
0 answers
22 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 ...
kataba's user avatar
  • 33
0 votes
1 answer
64 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, ...
Claus Koch's user avatar
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). ...
jared's user avatar
  • 113
0 votes
0 answers
69 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 ...
DavidMA2412's user avatar
2 votes
1 answer
201 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:...
KaliTheGreat's user avatar
0 votes
0 answers
20 views

Benefits of using pglogical 2.4.1 over Postgres 12 build-in logical replication?

I'm migrating a Postgres version 12.14 database. I've tested the migration twice: once using the pglogical extension 2.4.1 and once using Postgres' built-in logical replication. It seems like ...
trouble_bucket's user avatar
1 vote
1 answer
523 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 ...
JulioQc's user avatar
  • 143
0 votes
1 answer
26 views

aurora mysql - migrating large tables

We have write intensive application using aurora mysql 3.02 with 2xlarge instance size in prod. I want to migrate 10 tables (biggest one being 450GB) from 2nd aurora mysql into this prod db. Tried ...
JollyRoger's user avatar
0 votes
0 answers
93 views

Unable to resolve pyodbc dependency error while migrating SQL Server database to MYSQL

I am using MySQL workbench 8.0.35 to Migrate Database from SQL Server to MySQL. I have installed python 3.12.0 and pyodbc 5.0.1. When i select Start Migration in the MySQL workbench i am getting ...
pradeep3009's user avatar
0 votes
0 answers
58 views

MySQL 8: show deprecated error only as warning

I'm migrating MySQL from 5.7 to 8.0.32. I know character set utf8mb3 and its collations are deprecated. But we have lots of functionality and data with utf8mb3, and we don't have more time to change ...
yaki_nuka's user avatar
  • 141
0 votes
1 answer
100 views

Using logical replication to migrate a large Aurora database from AWS to on-premises PostgreSQL

After 5 years and many $$$ spent on keeping our data in an AWS RDS Aurora PostgreSQL cluster, we now want to bring the 12 TB of data back to an on-premises PostgreSQL instance, specifically a Crunchy ...
Robert's user avatar
  • 13
0 votes
1 answer
171 views

best practice for side by side sql version upgrade with Availability groups

We are attempting our first ever side by side upgrade of a 2 node(multi-subnet, enterprise edition) AG from sql 2016 to 2019. I have some questions on how best to approach this: Do we create a brand ...
DBA Greg14's user avatar
1 vote
0 answers
13 views

How do I migrate SQLite to Postgres for OWASP Juice Shop?

I tried to make a .sql but it's failing. My files here: https://drive.google.com/drive/folders/1BAs5YFPWpShzIgtd-NppL0iWZ_HywWNf?usp=sharing I also tried using pgloader but that was even more ...
mLstudent33's user avatar
0 votes
0 answers
89 views

AWS ORACLE to AWS RDS -- Error ORA-01406 even with the InlineLobMaxSize parameter set to 63

I am making a full load of a table with a 9 million rows with a lob column BLOB. And is about 100G in space, with AWS DMS With a Full LOB mode it takes an eterniy (More than 2 days). I tried Inline ...
user avatar
0 votes
0 answers
17 views

How to migrate from a MySQL master-master setup to a master-master setup with as little as possible downtime

I have to conduct a migration of a few databases from two MySQL VMs with master-master replication to another 2 VMS that would be also master-master replication. How would you do it with minimal ...
Zexxxx's user avatar
  • 1
0 votes
0 answers
113 views

How to migrate a database from Oracle to MySQL using the command line?

I am trying to migrate a database from Oracle to MySQL, with exp .dmp but I run into the problem that I must convert the .dmp file to .sql so that mysql recognizes it, for this conversion I cannot ...
user avatar
1 vote
1 answer
414 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 ...
Marek's user avatar
  • 13
1 vote
2 answers
118 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 ...
Ray's user avatar
  • 113
0 votes
1 answer
63 views

Migrate postgresql data directory from Windows to Mac[Silicon Based]

I have 4TB external portable hard disk with exFat formatting. Every day I use this disk as data directory for my postgresql 16. Every day I plug that external hard drive in my office windows pc and ...
Learner's user avatar
  • 99
0 votes
1 answer
160 views

Sql server migration side by side ( 2016 to 2019)

What is the best (i.e. fastest) way (backup and restore) for migrating a 6 TB database in SQL Server 2016 (Windows 2012r2) to another server, SQL Server 2019 (Windows 2019)? Can we, for example, ...
dba_rs's user avatar
  • 7
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 ...
user avatar
-1 votes
1 answer
74 views

Alternatives to reclaim free space after Shrink activity

For couple of our SQL server databases on version SQL2017 APP team did purge to change retention on these partitioned tables which has released quite good amount of space. Some background- Before ...
Newbie-DBA's user avatar
0 votes
0 answers
8 views

Moving Primary AG Replia to new location

DBA by accident here so apologies if I'm a little vague!! My current workplace use a three node SQL 2016 cluster, not virtual. One of the nodes is a primary replica and requires moving to a new data ...
Darren's user avatar
  • 1
0 votes
1 answer
105 views

Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?

Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link? I am getting ORA-00942: table or view does not exist when tried to query the same.
Arun's user avatar
  • 13
0 votes
0 answers
48 views

Why can't I migrate to a specific postgres database?

I am currently evaluating if it makes sense to migrate my existing, self-hosted MariaDB database to a managed PostgreSQL database in the cloud. For this task I am using the tool pgloader version 3.6....
zarathustra's user avatar
0 votes
1 answer
403 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 ...
Biller Builder's user avatar
0 votes
0 answers
34 views

Updating attributes, including PK and SK. Move up to 10 Billion records to new table, while still capturing live changes

Looking to shorten the attributes for some of our tables in DynamoDB, including the PK and SK and am currently brainstorming on what would be the best way to achieve this. The largest table has 10 ...
cb1295's user avatar
  • 101
0 votes
0 answers
67 views

Oracle Database schema validation

I am working on a database migration and want to validate the destination schema against the source schema for Tables, Views, Indexes, Sequences, Constraints etc. I can do that by querying the dba_ ...
JuniorDeveloper's user avatar
0 votes
0 answers
574 views

DBeaver database export not exporting foreign keys

I have DBeaver 23.1.0 on Windows. I want to export tables (PostgreSQL) from Database A to Database B, including foreign keys. What I found out was to mark all tables from Database A -> Right click -...
fabpico's user avatar
  • 111
0 votes
0 answers
136 views

Easiest way to migrate Availability Group databases from one cluster to another?

Consider this scenario: OLDCLUSTER (WSFC, all nodes SQL Server 2016 SP2) OLDSQL01 AG primary node OLDSQL02 AG secondary node OLDSQL03 AG secondary node (for DR) NEWCLUSTER (WSFC, all nodes SQL ...
Saverio Parlato's user avatar
1 vote
1 answer
1k views

AWS RDS MySQL upgrade from 5.7 to 8 failing due to ROW_FORMAT

We need to upgrade our DB to version 8, but we're getting an error in the migration log that's preventing us from upgrading. Creating indexes larger than 767 bytes on tables with redundant row format ...
user avatar
1 vote
2 answers
377 views

Migrating MySQL databases to a new server with phpMyAdmin

Looking for the best way to migrate a dozen or so MySQL databases from an old Mac mini to a new one. I've tried the source machine's phpMyAdmin (v. 4) EXPORT command, using what looked like reasonable ...
Rob Lewis's user avatar
  • 111
0 votes
0 answers
9 views

Facing Error Establishing a database Connection while migrating WordPress db

I am trying to migrate WordPress website to the local machine. I am using XAMPP. After downloading db from hosting provider, I have imported the db to a new db created in phpmyadmin and also ...
Adil M's user avatar
  • 1
0 votes
1 answer
25 views

How to migrate a database from 2016 to 2014 if there are encrypted/locked objects(SPs) associated with it?

I am trying to migrate a database from 2016 to 2014 through Task-->Generate Scripts. There are some stored procedures that are locked and seems like they are encrypted as well. They are causing ...
user2664231's user avatar
1 vote
0 answers
214 views

Best practice for long-running data migrations

We are using Flyway to manage migrations for our Postgres database. We leverage migrations for both modifying the database schema, as well as occasionally migrating data. When doing data migrations ...
Daniel Rearden's user avatar
0 votes
0 answers
13 views

Moving tables between postgresql schemas without messing up Hasura schemas

I have a database, which some teams are connecting to with their own Hasura instance. I inherited a DB where everything is in the public schema, and I want to refactor it so that different parts of ...
saolof's user avatar
  • 111
0 votes
1 answer
137 views

SQL Server database not able to update after restoration

We are migrating an application's database between servers and we have used the Attach method to attach the database files to the new location. After re-pointing the application to the new database ...
ETA's user avatar
  • 1
1 vote
1 answer
111 views

nodetool rebuild returned "Unable to find sufficient sources for streaming range"

We are migrating self hosted cassandra 3.11.6 to self hosted cassandra with k8ssandra-operator using cassandra 3.11.7. At some point of the migration we had to stop it due to other unrelated incident. ...
Mazurkim's user avatar
0 votes
0 answers
499 views

How to move Azure SQL managed instance cross tenants?

How to move Azure SQL managed instance cross tenants? I have some critical DBs hosted by Tenant_A's SQL MI A which need to be moved to Tenant_B's SQL MI B. They are all TDE encrypted by CMK. Is there ...
DBALUKE HUANG's user avatar
1 vote
0 answers
384 views

Best way to convert MSSQL Database to Oracle

I converted/migrated AdventureWorks with SQL Developer from MSSQL to Oracle with the SQL Developers option: Migrate to Oracle. You only have to create a schema for the Migration repository and create ...
Bandit84's user avatar
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 ...
cidy.long's user avatar
  • 133
0 votes
1 answer
796 views

How to check at what level/version is Db2 database?

On Linux x86_64 I installed Db2 v11.5.8.0 and I am in the process of upgrading instances and databases from v11.1 to v11.5. We have several Linux machines and they have at least two Db2 versions ...
folow's user avatar
  • 339
1 vote
1 answer
140 views

Migrate from MySQL 5.6.33 to 5.7.41 through replication without downtime

I have to migrate from outdated standalone MySQL 5.6.33 to new server with 5.7.41(a separate server) without downtime (or just as short as possible). To accomplish that I'm going to use replication (...
Artsiom Shymanouski's user avatar

1
2 3 4 5
19