Questions tagged [migration]

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

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

1
2 3 4 5
17