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



  • 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 migration.

    How to ensure that the source database cannot be modified during the migration?



  • you could adopt different strategies like:

    • close applications (usually difficult)
    • close firewall (usually difficult and it close connection to all databases)
    • set database in single user mode (you have to be carefull)
    • disable application logins (you have to close them all)
    • set database in read-only mode (my favorite)

Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2