Questions tagged [migration]
the process of moving databases or data from one place to another
864
questions
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. ...
user3432849
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...) ...
- 1
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 ...
- 41
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. ...
- 79
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 ...
- 113
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....
- 121
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 ...
- 23
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 < ...
- 205
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 ...
- 25
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 ...
- 1
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