Activity overview
Latest activity by nottinbe
Identity seed not preserved accross table rebuild.
Assume a table Test with a column with IDENTITY(1, 1).
If I insert 3 rows into that table, the seed value as reported by DBCC CHECKIDENT will be 3.
If I then delete the row with PK = 3, DBCC CHECK...
Is there any update on this? When a table is renamed there is a lot of manual intervention involved to get the synchronization correct.
Thanks,
Brian / comments
Is there any update on this? When a table is renamed there is a lot of manual intervention involved to get the synchronization correct.
Thanks,
Brian
I downloaded the latest RC of version 8. It is detecting differences in change tracking, but there is at least one case where the synchronization does not work.
In my source database i enabled change tracking on one table. It shows this in the bottom detail view. But when I go through the Synchronization Wizard, either by outputing the script to Management Studio or just having SQL Compare do it right away, the SQL to enable the change tracking on that table in the target database is not generated or ran.
Thanks,
Brian / comments
I downloaded the latest RC of version 8. It is detecting differences in change tracking, but there is at least one case where the synchronization does not work.
In my source database i enabled cha...
Change Tracking
Are there plans to support SQL08 change tracking?
Thanks,
Brian