Questions tagged [migration]
the process of moving databases or data from one place to another
921
questions
0
votes
0
answers
17
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
32
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
18
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
44
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
22
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
37
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
25
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
528
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
25
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
134
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
15
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
56
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
30
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
35
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
159
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