Skip to main content
Database Administrators

Questions tagged [sql-server-data-migration-assistant]

Ask Question

The tag has no summary.

13 questions
Newest Active Bountied Unanswered
1 vote
1 answer
27 views

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 ...
Sachintha Nanayakkara's user avatar
  • 31
2 votes
1 answer
91 views

I have a requirement to upgrade several SQL Server 2008 SP3 databases to a new environment on new servers running SQL Server 2022. As per Microsoft’s documentation, SQL Server 2008 cannot be upgraded ...
Sachintha Nanayakkara's user avatar
  • 31
0 votes
0 answers
59 views

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 ...
SakZepelin's user avatar
  • 21
1 vote
1 answer
272 views

There's a breaking change being highlighted in the Data Migration Assistant tool Syntax issue on the source server about the syntax of an object however I am unable to find this object. I've searched ...
ChrisCorner's user avatar
  • 21
1 vote
1 answer
375 views

I am trying to use Export data option to copy data from source to destination table wise, but it throws an error if there is any foreign key relationship, this error is because, if I selected a parent ...
Python coder's user avatar
  • 1
0 votes
0 answers
59 views

I'm working on azure SQL paas platform. Occasionally, I have to migrate data between databases. As you know there you need to define login and user for cross query connection. My question is: What is ...
dexon's user avatar
  • 67
-1 votes
1 answer
215 views

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 ...
variable's user avatar
  • 3,610
-2 votes
1 answer
1k views

Link: https://learn.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 ...
variable's user avatar
  • 3,610
0 votes
4 answers
630 views

Link: https://learn.microsoft.com/en-us/sql/dma/dma-bestpractices?view=sql-server-ver15 Check for untrusted constraints on both the source database and the target database before migrating data. ...
variable's user avatar
  • 3,610
0 votes
1 answer
234 views

I am planning to use the DMA tool for migrating sql server 2016 to sql server 2019. Both on-prem. I will be carrying out a test migration this weekend, followed by deleting the dbs and logins from the ...
variable's user avatar
  • 3,610
-1 votes
1 answer
39 views

I am performing a database migration (onprem sql 2016 to onprem sql 2019) using the DMA tool. The tool only supports one time migration in the above scenario. It does not support an ongoing continuous ...
variable's user avatar
  • 3,610
-1 votes
1 answer
400 views

I'm using DMA to migrate sql server from source server to target server (on-prem). After completing the migrate (for example it takes 1 hours and finishes at 2.30PM), meanwhile the source db is in use....
variable's user avatar
  • 3,610
-3 votes
1 answer
656 views

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 ...
variable's user avatar
  • 3,610