What are the challenges you face when working across database platforms? Take the survey
Options

Have option to exclude transactions

thirster42thirster42 Posts: 34
edited December 12, 2011 3:40PM in SQL Compare Previous Versions
Typically having the updates srapped in the transactions works fine. Where I run into issues is when I have a database that depends on linked servers a lot. SQL Server does not like accessing linked servers inside of a transaction. I find myself going through and manually executing each alter, create, or delete script for each individual object, and this gets a bit tedious.

It would be nice to have an option in SQL Compare to explicitly not have updates wrapped in transactions.

Comments

Sign In or Register to comment.