Questions tagged [migration]

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

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

1
2 3 4 5
16