Questions tagged [migration]
the process of moving databases or data from one place to another
846
questions
-1
votes
0
answers
11
views
How can I migrate data from one PostgreSQL database to another (with slightly different table/column names)?
I am trying to migrate a large portion of one postgres database to another postgres database that has a slightly different layout/table names/column names. But the data is the same. What is a good way ...
- 99
0
votes
0
answers
19
views
An error occurred during service master key initialization (sql error log)
I have migrated sql server 2017 to new hardware. The sql error log shows following error log whenever the sql server service is restarted.
An error occurred during service master key initialization
I ...
- 2,130
0
votes
1
answer
30
views
Postgres equivalent of Oracle's RMAN.VALIDATE_DATABASE
I am migrating a system using Oracle DB to Postgres (12.7). Various checks are run weekly against the existing DB, including a RMAN.VALIDATE_DATABASE (actually RDSADMIN.RDSADMIN_RMAN_UTIL....
- 121
0
votes
2
answers
37
views
Migrating SQL server to new hardware - restore msdb vs scripts job?
I am planning for sql server 2019 migration to new hardware.
For the server level logins, roles I can either restore the master db or script these out.
Similarly, for sql agent jobs I can either ...
- 2,130
0
votes
1
answer
31
views
What is the implication at attempting an attach without detach?
Sql server attach prerequisite states that a db must be detached before trying to attach it to another instance (https://docs.microsoft.com/en-us/sql/relational-databases/databases/attach-a-database?...
- 2,130
0
votes
0
answers
24
views
Why can't I use the present LUN approach for system dbs?
I'm planning to move sql server to new hardware, same version.
On the RHS, it is mentioned that script in system objects. Why can't I use the present LUN approach for system dbs?
- 2,130
3
votes
4
answers
461
views
The term Database Migration
I'm curious, when I first heard of the term database migration, it was unequivocally pertaining to moving entire databases from one platform to another.
However, recently I had to build a server that ...
- 33
1
vote
0
answers
14
views
Migrations spreading to the wrong database (local environment)
I am working on one Flask project and one Ruby on Rails project, both using Postgres. When I migrate in Rails, the changes are implemented both in this database and in the database for the Flask ...
- 11
-1
votes
1
answer
31
views
Does the DMA tool support an online migration for on-prem source and on-prem target?
I a planning to use the DMA tool to make a test migration from an on-prem source sql server to an on-prem target sql target.
This test will be performed during less busy hours, but there will be users ...
- 2,130
-2
votes
1
answer
21
views
What permission must the user have on source and target on-prem servers for DMA assessment and migrate to work correctly?
Link: https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15
It doesn't say anything on what exact permissions need to be given to the user on the source and target on-prem sql ...
- 2,130
0
votes
2
answers
21
views
How can I migrate data between 2 PostgreSQL clusters without auto-increment ID conflicts?
I have 2 database clusters that operate independently. In the future, I may need to move the records for a customer from cluster 1 to 2. I have a bash script where I do server-side copying of the ...
- 99
0
votes
1
answer
23
views
What exactly does `GRANT, REVOKE, and DENY Permissions on System Objects` mean?
Link: https://docs.microsoft.com/en-us/sql/relational-databases/databases/manage-metadata-when-making-a-database-available-on-another-server?view=sql-server-ver15#grant-revoke-and-deny-permissions-on-...
- 2,130
0
votes
1
answer
24
views
Does SQL server support database migration using LUN re-pointing for system, user databases across different sql server versions (2016 to 2019)?
I have SQL server 2016 on server A.
I want to migrate to SQL Server 2019 server B. I have installed the SQL server which auto creates the system dbs (master, msdb, model). D drive is for data files ...
- 2,130
0
votes
1
answer
21
views
How to handle logins and database users for migration of sql server into new domain (new installation, no trust with original domain)?
I want to migrate SQL server 2016 to SQL server 2019 (both machines are onprem, separate domain, no trust/connectivity between the domains, the new sql server will be a new installation on target ...
- 2,130
0
votes
1
answer
41
views
Whether to migrate database or logins first?
In a SQL server 2012 to SQL server 2019 migration, is it recommended to migrate the databases first or the logins first?
- 2,130
-2
votes
1
answer
35
views
Does database backup contain the user's GRANT, REVOKE and DENY permissions?
I am migrating database to another SQL server.
I have scripted the logins from the source server and migrated them into the target server. Also, I have backedup the source db and restored it on target ...
- 2,130
0
votes
0
answers
16
views
Migrate PostgreSQL between different releases (9.4 to 14)
I have a Debian 8 with Postgresql 9.4 server. I would like to upgrade it to the last version (Debian 11 with Postgresql 14). What would be the best practice? I was thinking of creating a new server ...
0
votes
1
answer
25
views
Check if pg_upgrade ran successfully
Is there a way to query the dB to know if pg_upgrade ran successfully and migrated the data? I want to know if a database is fresh post-installation or the data from the previous version has been ...
- 101
-3
votes
1
answer
43
views
Migration from Sybase to IBM-DB2 or Oracle?
We are planning to modernize our robust power builder /sybase application , that has around 500+ stored procedures,300+ tables. PB application produces 300+ reports,nothing but datawindows which has ...
0
votes
2
answers
38
views
Why do system objects need to be restored prior to user databases?
Link: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/choose-a-database-engine-upgrade-method?view=sql-server-ver15#migrate-to-a-new-installation
I'm migrating sql server 2016 to ...
- 2,130
0
votes
3
answers
64
views
How to migrate the permissions of logins - for example - grant/remove/deny permissions on system objects and server instance?
I'm migrating sql server 2017 to sql server 2019 on a separate machine.
I have backed up all the user databases, scripted all the sql jobs and logins.
On target server I will 1st run the logins script,...
- 2,130
-3
votes
1
answer
75
views
What is not supported by DMA (data migration assistant) for onprem to onprem SQL server migration?
I am using DMA with the intention to assess and migrate everything from an onprem sql server 2016 into an onprem sql server 2019.
It looks like DMA only allows migration of:
User databases, users and ...
- 2,130
2
votes
0
answers
41
views
Issues with SSISDB - SQL migration 2012 > 2016
I have a puzzle. We've been migrating a clustered instance from SQL 2012 to SQL 2016.
I didn't realize in advance that SSISDB requires additional steps and due to OS issues I cannot get access to the ...
- 23
0
votes
1
answer
16
views
Character set mismatch in database migration
I have an old database (MySQL 5.1.58) that I want to migrate to a new installation (MySQL 8.0.26). When I just use
oldserver ~$ mysqldump mydatabase > file.sql
newserver ~$ mysql mydatabase < ...
- 195
0
votes
1
answer
34
views
Importing data into Mysql slowly
This file is 23GB in size, it was created with Dump from the workbench
It starts well, but when it reaches 1/3 of the recorded data, the import starts to be extremely slow.
What do you suggest to ...
- 25
0
votes
1
answer
30
views
Transition from MongoDB Time Series Collections to InfluxDB
With version 5.0 MongoDB's specialized Time Series Collections were introduced to deal with such data. As I already stored some sensor meta data (configuration, specification ...) in MongoDB, I ...
- 103
0
votes
1
answer
42
views
What is the easiest way to migrate posgresql database to another server?
I have set up my PostgreSQL database on the server up and running, but soon the server is going to be destroyed, so I need to migrate the database to another server? What is the most comprehensive ...
- 1
0
votes
0
answers
44
views
Using User defined types in DB2 and using the type in a function
I am migrating my database from ORACLE to DB2, While doing the migrations I have come across a situation related to User defined types. As I have been working with DB2 recently, I have been through ...
- 1
1
vote
0
answers
47
views
Migrate MSSQL 2008 database to MySQL 5.7 or 8.0
I am trying to migrate an old database runing in SQL Server 2008, to MySql 5.7 or 8.0
using MySql Workbench (Migration wizard).
It gave me this errors
Traceback (most recent call last): File "...
3
votes
1
answer
119
views
Table names when migrating MySQL to Microsoft SQL Server
I've just migrated a MySQL database over to Microsoft SQL Server using Microsoft SQL Server Migration Assistant for MySQL. For some reason the table names in SQL Server are not named the same way as ...
- 133
2
votes
1
answer
222
views
How to migrate a mysql into a mariaDB docker container?
I am running a local instance of
$ mysql --version
mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
and would like to move the whole database into mariaDB docker container.
If I see ...
- 121
0
votes
0
answers
14
views
How to perform remote migrations without exposing a port?
I have some SQL migration scripts and my migration tool allows me to specify a remote target which works fine.
My concern is having to expose a port to the production database server. Normally I ...
- 101
1
vote
2
answers
164
views
InnoDB: Cannot close file ./tablefile.ibd because of 1 pending operations
MariaDB Version: '10.5.13-9
I am facing multiple unsuccessful data migration(Copy) attempts from my old legacy data environment to my DBaaS Container Environment. Performing this data migration using ...
0
votes
0
answers
106
views
Set 'WE8ISO8859P15' character set for existing Oracle 19c DB while migrating 12c DB
I have a database in 12c (12.2.0.1) which I need to migrate to an existing live oracle 19c DB.(This DB already hosts a couple of live DBs’s)
Character set of DB’s are as below:
12c -> ...
- 1
0
votes
2
answers
107
views
Migrating from old AlwaysOn Availability Group to new AG cluster but keep ip addresses
We want to migrate our SQL Server 2012 on server 2012R2 to SQL Server 2019 on server 2016 and keep the ip addresses but change hostnames.
i can not change the name of listener and ip addresses from ...
- 1,048
0
votes
0
answers
29
views
Best approach to extract 1000 Gbs of Data from Teradata
What should be the best approach to download data from Teradata using python ? I have more than 3000 GBs of data to be migrated from teradata to another code service. Any approach or advise would be ...
- 1
0
votes
1
answer
18
views
How to migrate MYSQL database with having different fields name?
I have two database old.sql & new.sql.
I have user table named user in new.sql. and users in old.sql.
table structure for user from new.sql
--
-- Table structure for table `user`
--
DROP TABLE IF ...
- 1
0
votes
0
answers
156
views
Migrating MS SQL Server Temporal Tables to AWS Aurora PostgreSQL
I'm hoping you can lend some pointers on this problem.
We are soon going to be undertaking a migration from AWS RDS MS SQL Server to AWS Aurora PostgreSQL mainly for cost savings and the ability to ...
1
vote
0
answers
55
views
Data migration assistant showing breaking changes/ behaviour changes for SQL 2019 but not for Azure SQL Managed instance
I am trying to assess the potential issues while migrating a SQL Server 2012 on-prem database to Azure, with SQL on Azure VM and Azure SQL Managed instance as targets.
For SQL on Azure VM, DMA is ...
- 111
0
votes
2
answers
24
views
Moving from MySQL 5.x to 8.x - fails due to column called "over"
Interesting and frustrating one, this. We have an old database that is still very actively used via multiple Excel files with VBA in, including archived projects with such files in.
There's a bit of ...
0
votes
0
answers
51
views
MS SQL Linked Server Insert Error
As part of data migration, I have created linked server for Greenplum database in MS SQL 2019. I am able to query using linked server. Select & insert commands are working fine for most of the ...
- 1
1
vote
1
answer
97
views
Using Microsoft Data Migration Tool on the command line
I am using the Microsoft documentation from the link below
https://docs.microsoft.com/en-us/sql/dma/dma-commandline?view=sql-server-ver15
The sample I am using from the documentation is this one
...
- 135
0
votes
0
answers
136
views
How to fully migrate data from dynamodb to postgresql
I have large data set inside dynamodb and want to move them all to postgresql and only can have 1 hour downtime. Whats the best tool or option to migrate and map all of my data from dynamo to postgres ...
- 101
0
votes
0
answers
109
views
Validation error while trying to migrate on-prem SQL Database to Azure SQL managed instance using Azure DMS
I have successfully created Azure Database Migration Project under Azure Database Migration Service
during the last phase of the project I am getting validation error
No valid full backup found for ...
- 1
0
votes
0
answers
45
views
DBMS_HS_PASSTHROUGH Bulk Fetch
i have question about DBMS_HS_PASSTHROUGH geting result set without stored_procedure
i have oracle and i have database link so i am running this query select * from table where id >20 via ...
- 3
-1
votes
1
answer
325
views
Sql plus equivalent in psql
I'm tasked of migrating some code from sqlplus to psql
In oracle, I have a bash script that excutes a stored procedure and based on the result it calls a sqlplus that spools multiple files to dump ...
- 11
0
votes
0
answers
21
views
Replace Postgres table while keeping foreign keys in other tables [duplicate]
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 ...
- 101
1
vote
1
answer
146
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": "...
- 1,199
0
votes
0
answers
28
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 ...
- 1
0
votes
1
answer
68
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 ...
- 327