Questions tagged [migration]
the process of moving databases or data from one place to another
915 questions
0
votes
1
answer
10
views
Question about using trace files with DMA during SQL Server migration assessment
When using Data Migration Assistant (DMA) for a database migration assessment, there’s an option to provide trace files from the source server for further analysis.
I’m wondering — is there a real ...
3
votes
2
answers
185
views
MariaDB 10.5 Migration Questions
I have a question, and I've found one similar addressed, which I was going to respond to with my own questions (Live database migration MariaDB 10.5 to MySQL 8.0), however, as that post/question is ...
- 31
2
votes
1
answer
608
views
Always on SQL Server upgrade / migration
We currently have a 3 node SQL Server Cluster with 1 node acting as the Primary, and the other 2 are Secondaries. These are configured in an Availability group. These are Windows 2019 servers running ...
- 61
0
votes
0
answers
33
views
Mongorestore DocumentValidationFailure Error while restoring oplog
I am trying to restore my oplogs from one database to another using mongodump & mongorestore utility. During dump I have faced no issue and overall dump was extracted but while restoring that dump ...
0
votes
0
answers
19
views
Migration Steps for msdb packages from SQL Server 2008 R2 to SQL Server 2019. Need Steps and requirements
We need to migrate msdb packages from SQL Server 2008 R2 to SQL Server 2019 SQL Server. What are the steps to take to migrate. Need SSDT Version and VS Version and the detailed steps if anyone has ...
user29600877
0
votes
0
answers
89
views
Migrate Postgres Database to MySql
Client exported his database that was created in Postgres but I am much more comfortable using MySql so I am trying to migrate the data cleanly and accurately into MySql from Postgres.
https://dev....
- 1
0
votes
1
answer
72
views
Migrating MySQL db with minimum downtime: how to migrate partially?
I have a 150+GB database I need to migrate to a new host. Most of the data is event logs, which I already partitioned "by hand" (into table_2020 etc.), and moved all past years (10 GB per ...
0
votes
0
answers
38
views
Migrating Publication database in Transaction Replication to another server
We need to migrate Publication database (SQL 2017) in Transaction Replication from old server (windows 2016) to new server with upgraded hardware (windows 2019). Please let me know if below approach ...
0
votes
0
answers
31
views
Migrate thousand of data from excel into DB
I have rental data from year 2019-2024 in an excel
In that excel, the data consists of tenant name, monthly payment details from jan - dec each year
I have done massaging the data
I need to mapping ...
0
votes
3
answers
169
views
Migrating SQL Server databases using differential backups, NOT transaction log backups
I need to migrate approximately 10 SQL Server databases totalling 400 GB from one VM to another. Some databases are in simple recovery mode, while others are in full. Below is my general plan:
A day ...
- 1
0
votes
1
answer
88
views
Migrating an existing sqlite database to postgresql
I'm trying to use pgloader to migrate an existing SQLite database to PostgreSQL. In a table of the database there are some columns of type boolean, since there is no dedicated boolean type in SQLite ...
- 101
0
votes
0
answers
57
views
Data Migration Assistant does not show the results of the assessment
I'm planning a migration of some SQL Server Databases to Azure
I installed the Data Migration Assistant in one of the servers in order to start an assessment to gather all the compatibiliy issues of ...
- 21
0
votes
1
answer
112
views
Microsoft asking me to remove Postgis to migrate database, any risk assoacited?
We are migrating our Postgresql Single Server to Flexible Server using Azure Migration and after a series of errors, the support engineer is telling me to remove the postgis extension for the ...
- 121
0
votes
1
answer
90
views
is it possible to bifurcate a SQL Server database on specific drives?
I have various databases in a SQL Server Instance hosted on-premise on a server, on say, the C Drive.
The intent is to migrate a small portion of this to a cloud provider, AWS.
So, let's say I have 2 ...
- 1,739
5
votes
1
answer
322
views
Frequent Statistics updates in SQL Server 2022 Enterprise Edition
We recently migrated our database from SQL Server 2014 to SQL Server 2022 Enterprise Edition. Our compatibility level is set for 160. After migration we observed few stored procedures started timing ...
Jaffer Mumtaz