Questions tagged [migration]
the process of moving databases or data from one place to another
777
questions
0
votes
0answers
10 views
“Percona-XtraDB-Cluster prohibits use of ALTER command on a table (<example>) that resides in non-transactional storage engine”
I installed a Percona XtraDB cluster with pxc_strict_mode set to ENFORCING, and am trying to import databases from non-Galera MariaDB servers. This works fine for some databases, by dumping them via ...
0
votes
1answer
24 views
migration by cloning a Production SQL Server host into a Dev environment
We are doing some SQL Server migrations, various versions, by cloning (snapshot backups) the host servers to the new DC in a different domain. Work is still in planning stage, not yet implemented. For ...
0
votes
1answer
26 views
SQL Server cross-forest migrate tasks
I’ve been doing cross forest migrations now. We have stand-alone some SQL Server machines. How can we migrate my database machines to target forest ? Is there any pre-migrate / post-migrate tasks ?
...
0
votes
1answer
6 views
Mongodb migration and appending data to existing database
I have two databases in two different machines containing data in same schema. Both have relational mappings in form of ObjectIDs as it is done in NoSQL database. The task at hand is to pick one ...
0
votes
1answer
36 views
Table design comment_seen vs comment_unseen — migrate data from one to another
I have system that allows comments posted by users and tracks which users seen which comments.
The read/unread state is tracked within comments_seen table. Surely enough, it grow tremendously.
My goal ...
0
votes
0answers
6 views
Merging two databases and sequence on Primary Key column
I'm using Database Migration Services on AWS to migrate data from 2 DBs and merge into 1.
The problem is with existing sequence on id column(in both databases) which is Primary Key too. I want to find ...
-1
votes
1answer
28 views
Migration from SQL SERVER 2008 R2 to 2019 with Log Shipping [closed]
Is possible to run swing migration from SQL SERVER 2008 R2 to 2019 with Log Shipping?
0
votes
0answers
19 views
running DDL and DML statements on multiple customer Mysql databases
We have a dozen customers who each have their own database (they are all on the same RDS instance). The database schema is exactly the same for all customers.
When a new code deployment feature ...
0
votes
1answer
34 views
Is there any other way apart from sa to login to a migrated instance where the target environment is in a different domain?
We are migrating sql server instances from one domain to a different domain. New AD accounts/groups will be used in the new domain so SQL logins and database users in the source SQL instances will be ...
0
votes
2answers
47 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 ...
1
vote
1answer
39 views
Netezza migration to Azure Synapse - Stored Procedures?
I have looked everywhere for useful documentation that comprehensively gives me the differences between Netezza stored procedures and functions so I can find Azure Synapse equivalents.
Is there any ...
0
votes
1answer
27 views
Do MySQL limitations apply to MariaDB as well on AWS RDS
I am thinking of migrating MariaDB 10.3.13 to RDS, I want to do an analysis of what limitation can be caused by migrating to RDS, I could find no documentation by AWS for MariaDB for issues and ...
1
vote
2answers
58 views
What extra work is required to restore a SQL Server instance and its databases included in a Windows Server snapshot backup?
We are migrating our SQL Server databases (various versions) from source Windows servers to new Windows servers. These are to be done by taking snapshot backups of of the servers. Does this server ...
0
votes
1answer
42 views
SQL Server License Migration [closed]
We need to move our SQL Server 2016 standard License. Our plan is to install SQL Server on the new box with the same license key , test the application / databases and then delete the old SQL server ...
0
votes
0answers
35 views
Error during migration run: “no PostgreSQL user name specified in startup packet”
When I go docker-compose up, I get this error:
yarn run v1.15.2
$ yarn migrate:run && yarn start
$ yarn typeorm migration:run --config ./lib/src/ormconfig
$ /usr/src/app/node_modules/.bin/...
-1
votes
1answer
36 views
Seeking advice on a DB project: hosting services [closed]
I am a new web developer who just finished a full stack boot camp. This question is to get advice and suggestions in building a free web-based database site for archaeology research. I would ...
0
votes
0answers
14 views
Use mysqldump for replication?
I have a large production database in Amazon RDS MySQL (billions of rows) that I want to set up as a master, replicating to an Aurora Serverless instance. Unfortunately, it looks like the only way to ...
0
votes
0answers
28 views
How to migrate SQL2014 to Azure SQL in short time (scripting)? [duplicate]
Context: The new application is ready to be used (Azure SQL). The old application is still used (MS SQL 2014). The switch from the old to the new is to be done during one night. The size of data is ...
1
vote
0answers
25 views
MySQL 8.0.x: Discard temporary table left behind during a pre-migration (5.7.x) crash when the parent schema is already dropped
We had a MySQL 5.7.x instance serving a production schema foo, and the server itself was migrated to 8.0.21 on 13 Sep 2020.
Recently we migrated data from foo to a new schema bar. After migration we ...
2
votes
0answers
38 views
What's the quickest way of porting thousands of PostrgreSQL queries to HSQLDB?
Lately we have been tasked with porting some existing DB infrastructure from PostgreSQL to HSQLDB. Yes, I know what you're thinking (why on Earth would anybody do such a thing?). But unfortunately for ...
1
vote
2answers
129 views
Converting SQL Server queries to PostgreSQL
I am trying to convert the following SQL Server T-SQL block to a PostgreSQL compatible one using, preferably CTE or a function. The issue with converting is I am not able to figure out how I return ...
0
votes
1answer
63 views
How do I import the _id index from a MongoDB collection as a hash index for a PostgreSQL table (from a CSV export from MongoDB)?
I want to be able to keep track of the _id index values that get the MongoDB collection uses when I export the MongoDB collection (via CSV) and import the data into a PostgreSQL DB table (basically ...
0
votes
1answer
23 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
0answers
16 views
Wrong column data types when using dtswizard
I need to copy a database from a MS SQL Server 2017 to a MS SQL Server 2012.
I am not sure what's the best way to go, but I'm currently trying to use dtswizard to do the job.
Everything seems to be ...
0
votes
3answers
70 views
disable log during migration?
We have an older SQL Server Database that is about 1TB.
We now have a new database that has a slightly different schema. We are going to migrate the 1TB of data to the new db using the export tool in ...
0
votes
2answers
52 views
How do I migrate Postgres database using an intermediate file
I have a PostgreSQL v9.5.23 database on an Ubuntu 16.04 server that I want to migrate to a new Postgres 12.4 installation on an Ubuntu 20.4 server.
The network pipe recommended by the Postgres docs ...
1
vote
1answer
94 views
Assign Failover Cluster and High Availability Always On from Old to New Domain
What are best practices steps when the Windows Server 2016 machine hosting SQL Server and failover cluster (2 node and shared folder witness) is joined to another domain?
What steps definitely/might ...
0
votes
1answer
28 views
How to export Sql Server DB schema as an ALTER statements?
I have a 2 months old DB & I want to fetch new Schema for that DB without deleting the data in it using ALTER statements. Is it possible?
Currently I am taking a backup of table data of Old DB in ...
0
votes
1answer
124 views
When I set Datestyle to 'SQL, YMD' all queries still return as 'SQL, MDY'
I am working on a database migration from Oracle 12c to Postgresql 12.
We must keep the same date format as the program interacting with this database is written in COBOL and should not be changed.
...
0
votes
1answer
58 views
migrating to a bigger server - how to copy over differences
We have a very large database, one table (logs) contains the majority of the data (around 13 billion rows) total database size is approx 6.5TB and I have 900gb of space remaining before server is full....
1
vote
0answers
24 views
Choose Right Azure SQL [closed]
I'm new to Azure and now trying to migrate the On-premises SQL databases on azure.
I have chosen VM SQL for migration because I just want to lift and shift architecture and need to restore backup file ...
0
votes
3answers
38 views
Is there performance loss in out of sequence inserted rows (MySQL InnoDB)
I am trying to migrate from a MySQL AWS RDS instance with a huge SSD and too much excess space down to a small one, and data migration is the only method. There are four tables in the range of 330GB-...
2
votes
2answers
255 views
Copy data to another database
I would like to know how to copy all the data from a database X1 into a database X2 on SQL Server please.
1
vote
0answers
16 views
Transaction log file - Migration SSMA
I'm attempting to migrate a relatively large Oracle DB to MSSQL using SSMA however due to disk space constraints, I had to stop the full migration last night when it was 50% of the way through.
Upon ...
0
votes
1answer
23 views
PostgreSQL know table hierarchy
Is there a way to know the parent - child relations (in terms of foreign keys) of all the tables in postgresql database? We are planning a full database migration using AWS DMS, we need specify in ...
1
vote
1answer
40 views
MYSQL Huge Data migration (5TB) from old server to new server
We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server in order to minimize the costs and get rid of very old hardware.
My one and only idea in my mind is using ...
0
votes
0answers
60 views
Migrate a DB2 table with BLOB to MySQL
I am trying to migrate a DB2 database (v 11.1) to MySQL (v 5.7). I have tried using DBConvert (https://dbconvert.com/db2/mysql/) which works quite well for "normal" tables but fails at a ...
0
votes
1answer
37 views
Migrate database to Azure
I have a 600GB database that I must transfer from an on-premises machine to an on Azure VM machine (IaaS)
I would like to use the dbatools copy-database tool for this
for this I will have to know what ...
0
votes
2answers
393 views
SQL Server 2016 -> 2019 AlwaysOn Rolling Upgrade Migration
I have a migration concept with an AlwaysOn configuration from SQL Server 2016 (on windows server 2016) to SQL Server 2019 (on Windows Server 2019) which are in different sub-networks.
So with ...
0
votes
0answers
17 views
Is it possible to convert Postgresql server to master-master cluster on the fly?
There is an Postgresql server that should never be stopped.
I want to upgrade it.
Is it possible to:
configure new empty server,
convert existing server to the first node of master-master cluster (...
1
vote
2answers
85 views
Provisioning SQL Server 2019
I'm provisioning a SQL Server 2019 build and have been allocated a virtual server running Windows Server 2016. It has 4 virtual processors and I have 410Gb of drive space to work with.
My build has to ...
1
vote
0answers
182 views
Migration from Postgres to MySQL using MySQL Workbench (Error in Reverse Engineering catalog. A task has failed while execution)
When I am trying to migrate database from Postgres to Mysql, I am facing an error in the Reverse engineering source step in which the log shows
Starting...
Connect to source DBMS...
- Connecting...
...
-2
votes
1answer
56 views
Shrink of a big databases ? SQL Server [duplicate]
In this moment I have a very big database (almost 4 TB) and wanna shrink data files for a future migration
Unused space : almost 3000 GB
I have in mind shrink data files day per day with low amount of ...
0
votes
1answer
14 views
Using IF … PREPARE … EXECUTE … DEALLOC to create a temporary block?
What are the comparative benefits of these two statements,
SET @stmt = (SELECT IF(
(
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND
...
0
votes
0answers
20 views
LIQUIBASE Locking our DB with duplicate IDs post migration - handling changesets
I apologize in advance if this is the wrong thread category but we recently migrated a DB and our liquibase configuration is seemingly not recognizing that there is a new path so Liquibase seems to be ...
0
votes
1answer
103 views
Upgrade Advisor Or DMA (Database Migration Assistant)
We are migrating from SSRS 2012 to SSRS 2017.
MS documentation suggests - "Even though you are migrating rather than upgrading the installation, consider running Upgrade Advisor on your existing ...
1
vote
1answer
43 views
Google Managed PGSQL DB migration to DigitalOcean Managed PGSQL DB
We are migrating from Google-Cloud PGSQL managed database to a managed PGSQL server on Digital ocean.
The dilemma we are facing is that both Google and Digital ocean are managed so we have no access ...
0
votes
0answers
62 views
Migrating sequences from postgres to EDB database
Scenario :
We are migrating data from a postgres DB to new EDB database .
We have migrated the sequence and all table data also .
Both DB is installed on a remote unix server and on diffrent machines....
-1
votes
1answer
44 views
Migrate data from an older version of mongodb
How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical.
We've tried by making a straight copy ...
0
votes
2answers
31 views
Do non-PostgreSQL database softwares use roughly the same “structure” for communicating with them?
Basically, I have developed a PostgreSQL-based application which "in theory" could have its database software swapped out, but probably would cause a million headaches if I actually ...
