verification of SQL Managed Instance migration

75 Views Asked by At

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.

1

There are 1 best solutions below

2
On BEST ANSWER

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