Issues I've Noticed
SQL Data Compare is a great product that makes my job much easier. But I have noticed a couple issues:
- Inserting and updating tables that are referenced by Indexed Views is very slow in SQL Server. Operations that would take a minute can take an hour. SQL Data Compare should drop these indexes before updates and recreated them afterward.
- SQL Data Compare can reseed on an identity column too low. Say for example you have Server1 with a seed of 100 and Server2 with a seed of 200. Maybe this is a development server and there has been a lot of testing. When you synchronize from Server1 to Server2, Server 2's seed will a be set to 100 and the rows from 101 to 200 will be removed. However, if someone were to perform an Inserting during the synchronization there could be a row with a value of 201 in the identity column. This could by adding an option to let SQL Server recalculate the seed column.
DBCC CHECKIDENT('schema.table', RESEED)
0 · Share on Twitter