Data Synchronization error from On Premise to Azure error

[atolmeijer]

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:

DBCC command 'CHECKIDENT' is not supported in this version of SQL Server.

Do you want to continue process?

[Yes] [No] [Retry] [Ignore All]

If I answer 'Yes' or 'Ignore all', nothing gets updated anyway.

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.

[alexa]

This issue happens due to being DBCC CHECKIDENT not supported by Azure anymore.

To avoid it, please unselect the 'Reseed Identity Columns' option on the 'Options' page of the Data Synchronization wizard.