Questions tagged [migration]

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

Filter by
Sorted by
Tagged with
-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 ...
user avatar
  • 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 ...
user avatar
  • 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....
user avatar
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 ...
user avatar
  • 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?...
user avatar
  • 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?
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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-...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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?
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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,...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 < ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 "...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 -> ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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": "...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 327

1
2 3 4 5
17