Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: sql-server-data-migration-assistant

What permission must the user have on source and target on-prem servers for DMA assessment and migrate to work correctly?

By adminPosted on April 4, 2022

Question : 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 […]

Does the DMA tool do absolutely no changes on the source sql server?

By adminPosted on January 11, 2022

Question : I am planning to use the DMA tool for migrating sql server 2016 to sql server 2019. Both […]

How to ensure that the source database cannot be modified when using the DMA’s migrate option?

By adminPosted on April 8, 2021

Question : I am performing a database migration (onprem sql 2016 to onprem sql 2019) using the DMA tool. The […]

How to do minimum downtime migration using DMA?

By adminPosted on August 26, 2020

Question : I’m using DMA to migrate sql server from source server to target server (on-prem). After completing the migrate […]

Does the DMA tool support an online migration for on-prem source and on-prem target?

By adminPosted on June 6, 2020

Question : I a planning to use the DMA tool to make a test migration from an on-prem source sql […]

What are untrusted constraints and what action needs taken to rectify?

By adminPosted on April 26, 2020

Question : Link: https://docs.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. […]

Recent Posts

  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow
  • mysql_query expected [closed]
  • Oracle not using index when > used in where clause

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding