Questions tagged [migration]
the process of moving databases or data from one place to another
924 questions
0
votes
0
answers
14
views
Migrating Publication database in Transaction Replication to another server
We need to migrate Publication database (SQL 2017) in Transaction Replication from old server (windows 2016) to new server with upgraded hardware (windows 2019). Please let me know if below approach ...
0
votes
0
answers
26
views
Migrate thousand of data from excel into DB
I have rental data from year 2019-2024 in an excel
In that excel, the data consists of tenant name, monthly payment details from jan - dec each year
I have done massaging the data
I need to mapping ...
0
votes
1
answer
61
views
Migrating SQL Server databases using differential backups, NOT transaction log backups
I need to migrate approximately 10 SQL Server databases totalling 400 GB from one VM to another. Some databases are in simple recovery mode, while others are in full. Below is my general plan:
A day ...
- 1
0
votes
1
answer
25
views
Migrating an existing sqlite database to postgresql
I'm trying to use pgloader to migrate an existing SQLite database to PostgreSQL. In a table of the database there are some columns of type boolean, since there is no dedicated boolean type in SQLite ...
- 101
0
votes
0
answers
30
views
Data Migration Assistant does not show the results of the assessment
I'm planning a migration of some SQL Server Databases to Azure
I installed the Data Migration Assistant in one of the servers in order to start an assessment to gather all the compatibiliy issues of ...
- 21
0
votes
0
answers
40
views
migration of table from one definition to another
In azure, regarding MSSQL
Is there way to migrate database table from one replica to another with different definition of table, such as different constraint from non-clustered to clustered key?
Are ...
- 21
0
votes
1
answer
36
views
Microsoft asking me to remove Postgis to migrate database, any risk assoacited?
We are migrating our Postgresql Single Server to Flexible Server using Azure Migration and after a series of errors, the support engineer is telling me to remove the postgis extension for the ...
- 121
0
votes
1
answer
63
views
is it possible to bifurcate a SQL Server database on specific drives?
I have various databases in a SQL Server Instance hosted on-premise on a server, on say, the C Drive.
The intent is to migrate a small portion of this to a cloud provider, AWS.
So, let's say I have 2 ...
- 1,709
5
votes
1
answer
143
views
Frequent Statistics updates in SQL Server 2022 Enterprise Edition
We recently migrated our database from SQL Server 2014 to SQL Server 2022 Enterprise Edition. Our compatibility level is set for 160. After migration we observed few stored procedures started timing ...
Jaffer Mumtaz
0
votes
0
answers
11
views
Database migrations under DynamoDB - Move entries to code, and create a pipeline
We have a DynamoDB based config. We want to transfer all the configs inside the DDB to a code package. We then want to create a pipeline from the said code package to the DDB, which then handles all ...
- 101
0
votes
0
answers
28
views
DMA - need clarity
We have an old SQL Server 2008 R2 and we are trying to migrate to the latest SQL Server version. My product owner is asking me to check the compatibility of stored procedures with the new version.
...
0
votes
1
answer
45
views
Migrating Cassandra cluster between different AWS accounts
Note: The two different accounts could be as well two different physical locations. I would expect the answer to not change based on such a detail.
I have a DSE 5.1.x production cluster of 6 nodes + ...
- 63
1
vote
0
answers
39
views
After nodetool refresh number of records in the source is much larger than in the target instance
Restore snapshots to another cluster (migration)
source:
Scylla v. 4.4.1 on Kubernetes,
4 nodes e.g. a1,a2,a3,a4
target:
Scylla v. 5.4.6 - no Kubernetes installation
4 nodes e.g. b1,b2,b3,b4
Steps:
...
0
votes
0
answers
32
views
Trino. Export data from postgresql
I am exporting data from PostgreSQL to another database using the following query:
INSERT INTO db_name.public.example_table (id, name, content, boolean, timestamp) SELECT id, name, content, CAST(...
- 1
0
votes
1
answer
107
views
MariaDB Performance Degradation After Brief 20 Hour Massive Improvement
Problem
On 2024-05-07 20:00:00 we migrated our DB from MariaDB 10.5 on an 8 core 16GB RAM server with a 10GB innodb buffer pool to a MariaDB 10.11 server with 16 cores 32GB RAM and a 20GB buffer pool ...
1
vote
0
answers
54
views
Azure SQL Migration extension don't support MFA authentication
I'm trying to migrate an on-prem Sql Server database to Azure SQL Database. I'm using Azure Data Studio with Azure SQL Migration extension.
My problem is that Azure SQL Database is configured by dba's ...
- 111
0
votes
1
answer
56
views
AWS RDS DB Migration
I have a PostgresFB on an AWS RDS instance that we want to migrate to an on-site server. The problem we having is the migrating of data and the time it is taking to migrate the data.
I have tried AWS ...
0
votes
0
answers
58
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 ...
- 101
0
votes
1
answer
961
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 ...
0
votes
0
answers
29
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 ...
1
vote
2
answers
233
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 ...
- 11
0
votes
0
answers
21
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?
0
votes
1
answer
75
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) ...
- 11
0
votes
0
answers
37
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 ...
- 1
0
votes
0
answers
55
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 ...
- 33
1
vote
1
answer
261
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, ...
- 21
0
votes
0
answers
100
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).
...
- 123
0
votes
0
answers
271
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 ...
2
votes
1
answer
606
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:...
- 189
1
vote
1
answer
2k
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 ...
- 143
0
votes
1
answer
47
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 ...
- 11
0
votes
1
answer
291
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 ...
- 125
0
votes
1
answer
463
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 ...
- 255
1
vote
0
answers
26
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 ...
- 115
0
votes
0
answers
155
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 ...
Zuriel_Owsla
1
vote
1
answer
1k
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 ...
- 13
1
vote
2
answers
228
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 ...
- 113
0
votes
1
answer
110
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 ...
- 99
0
votes
1
answer
340
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, ...
- 7
0
votes
2
answers
25
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
...
Suraj Kumar
-1
votes
1
answer
130
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 ...
- 794
0
votes
1
answer
203
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.
- 13
0
votes
1
answer
916
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 ...
- 286
0
votes
0
answers
83
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_ ...
0
votes
0
answers
915
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 -...
- 111
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 ...
user3411972
1
vote
2
answers
655
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 ...
- 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 ...
- 1
0
votes
1
answer
35
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 ...
1
vote
0
answers
351
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 ...
- 243