azureazure-sql-managed-instancesqlmigrations

verification of SQL Managed Instance migration


is there a way to verify that a SQL Server to an Azure SQL Managed Instance migration was successful? More detailed question would be, how can I check that there is no data corruption? Is there is not, it is because CHECKSUM in Backups is enough?

Thanks! Much appreciated.


Solution

  • It depends on how you are doing the migration. If you are taking backups -> upload to Blob -> Restore to Azure SQL MI, then taking backups with checksum and verify option should be good enough.

    If you want, you can run DBCC for peace of mind but I haven't seen any issues during migrations.

    Hopefully this helps