Activity overview
Latest activity by bpage
I have seen this in several .NET applications. There doesn't appear to be any rhyme or reason, but Red Gate is not alone in this. I've even seen this in SSMS. / comments
I have seen this in several .NET applications. There doesn't appear to be any rhyme or reason, but Red Gate is not alone in this. I've even seen this in SSMS.
Request: Disable Indexed Views
Updating tables with Indexed Views dependent on them can take a long time (hours). Can you add support for removing Indexed Views and recreating them after synchronization? This should work just li...
I see this is a duplicate post. I searched before I posted, but apparently your forum doesn't do partial matches.
ie. Searching for reseed will not match reseeding. / comments
I see this is a duplicate post. I searched before I posted, but apparently your forum doesn't do partial matches.
ie. Searching for reseed will not match reseeding.
Will you please sent this to me as well? SQL Data Compare is mangling my database. I have to run SQL Compare after synchronize to turn some of the check constraints back on. / comments
Will you please sent this to me as well? SQL Data Compare is mangling my database. I have to run SQL Compare after synchronize to turn some of the check constraints back on.
SQL Data Compare RESEEDs everything
SQL Data Compare is RESEEDing everything on the destination server with the IDs from the source server, even if the table is question is not checked in the list and no data is synchronized for that...
Chris Auckland wrote:
Thanks for your post.
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 has the option to 'Drop primary keys, indexes, and unique constraints'. This option will drop and then recreate the PK's, indexes and unique constraints in the generated SQL script. The option can be found in Options > Synchronization Behaviour. Hopefully it will do what you need.
This does not drop Indexes on Views that reference the table. That's my point. It really should. These indexes place constraints on the table just as if there were on the table itself and the enforce schemabindding on the table. / comments
Chris Auckland wrote:
Thanks for your post.
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. S...
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...