Questions tagged [migration]
the process of moving databases or data from one place to another
793
questions
-1
votes
1answer
21 views
How to migrate from MySQL 5.7 to 8.0 non-inplace
Hi I have a new Ubuntu 20.04 server, and an old 18.04 server which I am retiring. 18.04 runs MySQL 5.7 and 20.04 runs MySQL 8.0. In the old days, I'd simply do a mysqldump --all-databases and then ...
0
votes
0answers
13 views
Not able to connect to the target endpoint in dms
Actually i have a requirement to migrate the database from AWS RDS to on premises.I have ubuntu as my on premises server. For that i have to setup a dms task and i have created the replication ...
-2
votes
0answers
22 views
Automating ETL RDBMS to RDBMS [closed]
We have a complex SQLServer database built to the big-ball-of-mud design philosophy. Every aspect of the entire company is in one sprawling database with thousands of tables, views, and stored ...
0
votes
0answers
11 views
GCP CloudSQL: DMS migration with existing CloudSQL instances
We are planning to make a switch from On-Premises Mysql servers to Google's Cloud SQL. For that we are planning to use the DMS service provided by Google.
Everything else checks out okay, but we want ...
0
votes
1answer
20 views
Mysql v5.1/RHEL6 dump to MariaDB v10.3/RHEL7 restore process
I am moving a number of databases from a MySQL 5.1 RHEL6 server to a MariaDB 10.3 RHEL7 server. Do I need to run mysql_update after doing the dump/restore of each DB, or is that just for system tables ...
2
votes
1answer
234 views
Hosting older SQL DB on new server - what's the maximum compatibility level I can set
With regards to backward compatibility, what is the maximum compatibility mode I can set on some of the older databases which may be hosted within a newer version of SQL Server (SQL Server 2019 to be ...
0
votes
1answer
21 views
Migration db (error when alter DB)
i am new as DBA. i want to migrate db, can i do one time alter for all data ?. or must one alter to one data ?
this my query.
DECLARE @name VARCHAR(50)
DECLARE db_cursor CURSOR FOR
SELECT name
FROM ...
0
votes
0answers
45 views
Super complex Schema will not migrate to PaaS
Using a Dedicated 2016 datacentre SQL Server 2 vcpus, 14 GiB memory for testing.
We have currently found a migration issue with the database Migration SQL 2016 to Azure PaaS.
The transfer of schema ...
0
votes
1answer
22 views
SSRS migration with Same Name and Moving of Reporting Files
This is will be my first SSRS migration and please bear with me if some points don’t make any sense.
I need to migrate the Reporting server but need to keep the same name so that the reporting URL don’...
0
votes
1answer
28 views
Please confirm pre and post sql server instance migration steps
I would appreciate some help please.
We are migrating a number of VMs with different versions of SQL instances from site A to site B, one instance per VM. Site A and B are in different domains. In ...
2
votes
1answer
95 views
Equivalent of a SQL Server schema in MySQL?
I have a modular system that is being migrated to MySQL.
In SQL Server, there is this concept of the schema for grouping tables and database objects together. For example, all user-related tables can ...
0
votes
1answer
18 views
How do I tell if a long running update won't lock the database?
There is a update query I need to run on a table in production. The update would touch millions of rows and I would take a couple of minutes.
The database is Mysql.
I was wondering if the table would ...
0
votes
2answers
30 views
SQL Server Migration Plan - Alias Options for Multiple Apps Connecting
We currently have a number of databases on a single SQL Server 2008R2 instance (server name: prdServer01; Win VM). We want to migrate to a SQL Server 2016 instance (server name: prdServer02; Win VM).
...
0
votes
1answer
185 views
Why do I get ERROR 1824 (HY000) while importing MySQL dump from 5.7 to 8.0.x?
I have a MySQL 5.7.x dump with about 12GB that I try to import into a newly installed MySQL 8.0.x local instance.
mysql -u username -p test < DB-210508.sql
The import starts but fails with the ...
0
votes
0answers
11 views
Constraints number is differents after migrating from postgres 9.6 to 12.5
I have 2 postgres versions : 9.6 and 12.5
I have loaded the same database in them ( the famous dvdrental database)
I was checking the differences between the 2 databases running multiple queries for (...
2
votes
0answers
40 views
Migrate Mysql to Azure Sqlserver db
I read some articles and also tried SSMA, linked server and other things, but not help. I have one client's mysql Db (later we need other too) in my local pc and have Azure DB which used for SAAS-...
-1
votes
1answer
197 views
Update and migrate database from SQL Server 2014 to SQL Server 2019
I want to update and migrate database from SQL Server 2014 to SQL Server 2019 so that if there is any failure at SQL Server 2019 I will come back at SQL Server 2014 and get all the transactions back ...
0
votes
1answer
37 views
Migrate from Standalone Instance to Failover Node Instance
I am fairly new to the MS SQL and i am currently working on a project at my company. We have a ERP System built on a SQL Server and we want to create a SQL failover node.
The original configuration is ...
0
votes
2answers
73 views
What is Fastest way to shrink a datafile?
I have a 4 Tb SQL Server 2008 R2 database. I'm going to move this DB to a new server with a new release of SQL Server 2012. (the application does not support SQL Server > 2012, but that is not the ...
0
votes
0answers
59 views
Database Migration Failed from MSSQL server 2014 to Oracle 19c
We have SQL server 2014 and we are trying to migrating the database to Oracle 19C eventhough after following the proper steps mentioned in Oracle and followed by some youtube videos with proper admin ...
0
votes
1answer
87 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
28 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
7 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
42 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
14 views
Merging two databases and sequence on Primary Key column [closed]
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
79 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
20 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
84 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
73 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
32 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
61 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
46 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
94 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/...
0
votes
1answer
84 views
Convert SQL server stored procedures to postgreSQL
I have a SQL Server database that I am migrating to PostgreSQL 12.0.
I have managed to migrate the schema and the tables. The applications connecting to the database rely a lot on stored procedures, ...
-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
32 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
82 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
40 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
214 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
101 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
36 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
114 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
95 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
145 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
29 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
225 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
59 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....
