Data Synchronization error from On Premise to Azure error
Posted: Wed 09 Oct 2013 06:02
When I synchronize data in the data comparison tool (I have the latest version 3.0.230) from my local SQL Server 2012 instance to my SQL Azure database, I receive an error:
When I generate the script and send it to the internal editor, I can see that the statement
DBCC CHECKIDENT('dbo.Medewerker', RESEED, 222)
cannot be executed on Azure.
If I answer 'Yes' or 'Ignore all', nothing gets updated anyway.DBCC command 'CHECKIDENT' is not supported in this version of SQL Server.
Do you want to continue process?
[Yes] [No] [Retry] [Ignore All]
When I generate the script and send it to the internal editor, I can see that the statement
DBCC CHECKIDENT('dbo.Medewerker', RESEED, 222)
cannot be executed on Azure.