Questions tagged [migration]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
17 views

Oracle partition exchange to migrate one database to another to improve the ETL performance

We are moving from one system to another and there is a very large migration of data involved. We want to minimise the downtime to the business, and therefore we need to optimise the ETL process. ...
's user avatar
0 votes
0 answers
7 views

Oracle Reference Partition migration to Postgresql

We are in process of migrating from Oracle 19c to Postgresql v13. We have a table in Oracle which has numerical primary key and is range partitioned based on a date column. This table has 3 child ...
  • 101
0 votes
0 answers
16 views

I need help with Migrating a 2008 R2 SSRS to a new 2019 SSRS

We are migrating a 2008 r2 SSRS to a 2019 SSRS, do i need to upgrade on the current before the migration, I need advice please what can i do? How can i make the migration successful. Please take note ...
  • 13
0 votes
0 answers
27 views

slow queries after migrating from mariadb 10.3 to 10.6

I have a query like this : select t.c1, t2.c2, ... my_function(t1.id) /*this function is used in many queries to avoid repeating code*/, ... from t1 left join ... lot of joins ... where t1.status='...
2 votes
1 answer
42 views

Postgres nondeterministic collation performance

After reading documentation I thought I should ask about the performance issues with the case insensitive behavior I am looking for. For context, I am working on a migration project from SQL Server to ...
0 votes
0 answers
27 views

ERD Design for mangers and their respective locations

I am tasked with replacing the company spreadsheet containing all our sites and which belong to the three upper managers in their respective hierarchy to a relational database. This is a relatively ...
0 votes
1 answer
46 views

How to migrate sql server (large db size) and retain all settings and backup/job history?

I am looking at migrating sql server with 25 databases of total size 7TB to a new machine (better hardware). All settings (logins/dbmail/proxy/credential/lonked servers), and backup/agent job history ...
  • 2,808
0 votes
1 answer
59 views

Migrate databases between Azure managed Instance and Azure SQL VM

(scroll to the end of the post to see latest development) There's a necessity for migration of 3 databases from Azure MI to Azure SQL VM (OS 2022, SQL 2019 standard). Each database has 500GB+. Each ...
  • 105
0 votes
0 answers
26 views

Fastest way to migrate largish (15 TB) PostgreSQL 11 instance to Aurora 14 in AWS

We have an AWS RDS PostgreSQL 11 cluster (currently version 11.13), in which we have a few databases and some 1500 tables. The RDS cluster is of size "db.r5.xlarge", with 4 vCPUs, 32 GB RAM ...
  • 3
-3 votes
1 answer
92 views

Why do indexes, statistics, and full text need to be rebuilt/updated/repopulated after migration?

I have created a new server, restored the system dbs and presented a copy of the data/log disks from the previous machine (or alternatively maybe I restore the user dbs using the .bak files). Post SQL ...
  • 2,808
0 votes
1 answer
64 views

How to "clone" entire MS SQL base to another host?

I'm rather new to MSSQL and maybe a task is very simple. I have WinServer 2016 and SQL Server 2016. I need to copy/clone/migrate everything about SQL server (logins, procedures, schedules, tables...) ...
0 votes
1 answer
39 views

How do I change the Cassandra topology + snitch in a multi AZ cluster?

I have a 9 nodes Cassandra v3.11 cluster in one availability zone with SimpleSnitchStrategy. I want to change the snitch strategy to GossipingPropertyFileSnitch and the topology to be multi AZ like ...
-1 votes
1 answer
23 views

How do I migrate a Northwind DB to Cassandra? [closed]

I want to migrate data from a Northwind database to Apache Cassandra. How would I go about modelling the data for NoSQL? What are the recommended techniques and/or methodologies to accomplish this? I ...
  • 1
0 votes
0 answers
13 views

Two node AG (async, manual failover)...Zerto migration of primary node AND file share witness vm...quorum will fail temporarily

We've been migrating (using Zerto) individual sql vms to a new data center, and our AGs are up next. With a two node AG (async, manual failover, file share witness) where the primary node and the vm ...
0 votes
0 answers
39 views

Migrate DB2 to MySQL

Is there any way or tools to migrate tables, stored procedures, views, data, functions and triggers from DB2 to MySQL? I have tried some tools but it only provide tables and data migration. Do I have ...
  • 1
2 votes
1 answer
22 views

MySQL InnoDB migrations custom implementation: How to deal with DML statements which trigger a commit in the background?

After some discussion on that topic I can assume that there is a quite frustrating fact about MySQL InnoDB: It does not support (atomic) transactions when it comes to DML. If you have a database ...
  • 215
0 votes
1 answer
46 views

How to replicate between On-Premises and Azure in Mongodb

I have three 3 node cluster on-premises ( 1 Primary and 2 Secondary ). I have same 3 node cluster in AZURE ( 1 Primary and 2 Secondary ) with same version and data but with different FQDN in azure. ...
0 votes
0 answers
128 views

MySQL Workbench Migration and PostgreSQL ODBC, cannot connect

I am trying to migrate a PostgreSQL database to MySQL using the MySQL Workbench's Migration Wizard tool. I am on Debian 11 bullseye and installed MySQL Workbench 8.0.25 using Snap. It works fine, ...
0 votes
1 answer
54 views

Upgrate postgresql database

I'm going to upgrade postgresql from the version 9 to 11, I exported all the cluster using the command pg_dumpall -h localhost -p 5450 > /tmp/all.sql I have installed postgresql 11 on my new ...
0 votes
1 answer
42 views

Should I backup and restore the SMK when performing a server upgrade and migration?

I understand that the SMK is used to encrypt sensitive data like passwords in the linked server configuration. Hence when I migrate or upgrade the sql server to another computer, then I assume I ...
  • 2,808
0 votes
1 answer
16 views

Enabling replication in MySQL in fresh database

We have a legacy TokuDB database that we would like to begin migrating to a new engine. Unfortunately taking the db offline for migration is not feasible. We also can reprocess all the data in the ...
0 votes
0 answers
197 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,808
0 votes
1 answer
62 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....
0 votes
2 answers
79 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,808
0 votes
1 answer
45 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,808
0 votes
0 answers
25 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,808
3 votes
4 answers
490 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
18 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
40 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,808
-2 votes
1 answer
84 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,808
0 votes
2 answers
60 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 ...
  • 109
0 votes
1 answer
27 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,808
0 votes
1 answer
31 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,808
0 votes
1 answer
205 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,808
0 votes
1 answer
71 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,808
-2 votes
1 answer
43 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,808
0 votes
0 answers
99 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
69 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
54 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
44 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,808
0 votes
3 answers
100 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,808
-3 votes
1 answer
210 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,808
2 votes
0 answers
110 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 ...
1 vote
1 answer
46 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 < ...
0 votes
1 answer
53 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 ...
0 votes
1 answer
197 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
416 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 ...
0 votes
0 answers
60 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
97 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
250 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 ...
  • 143

1
2 3 4 5
18