Questions tagged [migration]
the process of moving databases or data from one place to another
806
questions
0
votes
0answers
14 views
Replace Postgres table while keeping foreign keys in other tables
I have a project where I'd like to replace all the rows in a table periodically with new data. That data will 99% of the time have the previous rows with updated data and some new ones.
There are ...
0
votes
0answers
4 views
What does MISSING_TARGET means on Amazon DMS (Database Migration Service) validation?
I'm running Amazon DMS from RDS to Aurora, the error when full restarting (never been successful before) from awsdms_validation_failures_v1 tables are:
[
{
"TASK_NAME": "...
0
votes
0answers
19 views
How to resolve the "file 1 needs media recovery" error in Oracle 11g?
I am trying to migrate oracle 11g database from Windows to a Linux server. I have followed these steps for migration:
I have opened database in mount mode.
Then I have backed up file on the Windows ...
0
votes
1answer
62 views
Moving entire SQL Server 2016 to a new location - best method
At my organization, we have a SQL Server (2016) running on an EC2 instance at Amazon on a Windows with SQL Server license. My boss realized we could save a ton of money by standing up a Windows-only ...
0
votes
0answers
15 views
how to migrate on-premise oracle databae to oracle cloud?
I want to migrate my on-premise oracle 11g database to oracle cloud(11g) database.
-my system is windows 64bit.
-i have already created free tire account in oracle cloud and inside db system i have ...
-1
votes
1answer
23 views
How to test a virtual postgres 9.6 server will be greater than a physical postgres 9.6 server
We have a physical postgres server running on 9.6, I am looking to virtualize this server, but want to if possible utilise old postgres WAL logs if its doable?
Is it possible to replay the same ...
0
votes
0answers
34 views
load large data and split and store into two tables in sql server
I need to take large amount of data from a table and split that into two different tables in databse (sql server). How it is possible. i need to automate this action either in sql server side or ...
0
votes
1answer
18 views
Incorrect migration of an object from Firebase to MongoDB
I am in the process of migrating a database from Firebase to MongoDB and am facing a problem. Here is such an object I have stored in the FB:
"logs": {
"2021-05-24": {
&...
0
votes
0answers
13 views
How to migrate from Aerospike to DynamoDB
I have a client running Aerospike 3 with a maxed-out database (around 20 TB) who needs to migrate to AWS DynamoDB. Does anyone have any comments on the best way to do this, or pitfalls? In particular, ...
1
vote
0answers
44 views
Default logins after installating SQL Server 2019 [duplicate]
I migrated my old logins from a SQL Server 2017 instance to a newly installed SQL Server 2019 instance, by following Microsoft's guidelines:
https://docs.microsoft.com/en-us/troubleshoot/sql/security/...
2
votes
1answer
67 views
DB Migration complication
I am currently working on a database migration use case where the requirement is to migrate a database of size 220 GB from a source SQL Server 2005 (installed on Windows 2003 Server R2 edition, ...
1
vote
0answers
48 views
SQL Server: Track new rows across all tables
I am in the middle of collecting data from SQL Server to other locations for processing and storing and I need to find a way to only SELECT new rows since last nightly data collection so I dont need ...
1
vote
0answers
52 views
RAM problem when migrating Oracle DBs onto new server
Sorry for posting this again but the old post has been locked for serveral days now and i can‘t add any new details on there.
We have multiple Oracle databases on an old server and want to migrate ...
0
votes
1answer
21 views
Inserting data from one database to another database in specific columns not working [closed]
I have csv formatted data, i want to put the data to my existing database's table in specific columns. I was trying to do it with LOAD DATA INFILE... and i have even uncomment the mysqli....
0
votes
1answer
36 views
How to forcefully drop all active connections off a database?
On one server I have a Postgresql database and there're many clients on other servers accross the internet that connect to it. I want to drop all the active connections on demand, they should be ...
-1
votes
1answer
131 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
15 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
243 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
22 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
46 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
30 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
35 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
171 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
43 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
34 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
532 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
14 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
44 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
495 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
51 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
166 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
109 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
190 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
37 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
8 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
18 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
417 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
23 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
35 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
164 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
92 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
37 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
61 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
127 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
2answers
264 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
37 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
47 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 ...
