We need to migrate a database from SQL Server to an Azure SQL Database. In this database we do use rowversions (timestamp) extensively for synchronisation purposes with other systems. It is therefore important that these rowversions remain unchanged.
Normally, restoring a database using the regular BAK file will preserve all rowversion values. However, I do not think it is possible to use these backup files to restore the data in Azure SQL Database.
I have tried a few ways of migrating the data, all resulted in new rowversion values. Tried methods:
- Migrate using SQL Management Studio (option: Deploy Database to Microsoft Azure SQL Database...)
- Using Microsoft Data Migration Assistant tool
- Import a bacpac file using the Azure Portal
Is there a way to migrate a database from a SQL Server to an Azure SQL Database, while preserving the rowversions? And if not, is there a way to bumb up the database timestamp (@@DBTS) so we can make sure new rowversions are always larger in value than the original rowversion value?