Activity overview
Latest activity by Simon C
Unfortunately, this isn't currently possible with the current version of SQL Compare. DML triggers and indexes are treated as part of a table, and changing this would require a large rewrite of the core of the SQL Compare engine. It is something that's been requested quite a few times before, so it is something we might consider in a future version.
Simon C / comments
Unfortunately, this isn't currently possible with the current version of SQL Compare. DML triggers and indexes are treated as part of a table, and changing this would require a large rewrite of the...
It looks like SQL Compare is obtaining wrong version information from the connection information with the server. Do you have access to visual studio you can run a small console app with? / comments
It looks like SQL Compare is obtaining wrong version information from the connection information with the server. Do you have access to visual studio you can run a small console app with?
PAD_INDEX is SQL 2000 syntax, PAD_INDEX = ON is SQL 2005/8 syntax. What version of SQL Server are you running the script on, and what's the compatability mode of the database? / comments
PAD_INDEX is SQL 2000 syntax, PAD_INDEX = ON is SQL 2005/8 syntax. What version of SQL Server are you running the script on, and what's the compatability mode of the database?
I'm afraid this is a known issue with the 8.0 release. We are currently working on a patch release to fix this issue, and will let you know when this is available.
Simon C / comments
I'm afraid this is a known issue with the 8.0 release. We are currently working on a patch release to fix this issue, and will let you know when this is available.
Simon C
This is indeed something we missed in the documentation; ReseedIdentity is a default option. The full list is:
IgnoreSpaces, IncludeTimestamps, IncludeIdentities, DisableKeys, OutputCommentHeader, ReseedIdentity
Thanks for letting us know; we will update the online documentation and the commandline help in the next release
Simon C / comments
This is indeed something we missed in the documentation; ReseedIdentity is a default option. The full list is:
IgnoreSpaces, IncludeTimestamps, IncludeIdentities, DisableKeys, OutputCommentHeader, ...
No, I'm afraid you're unable to modify the object model after the database registration has taken place. You would have to modify the objects on the database itself to change the resulting object model in SQL Compare.
Simon C / comments
No, I'm afraid you're unable to modify the object model after the database registration has taken place. You would have to modify the objects on the database itself to change the resulting object m...
The Text property is available on the DdlTrigger, Function, StoredProcedure, Trigger and View classes, accessible through the ObjectIn1 and ObjectIn2 properties of the Difference class / comments
The Text property is available on the DdlTrigger, Function, StoredProcedure, Trigger and View classes, accessible through the ObjectIn1 and ObjectIn2 properties of the Difference class
Unfortunately, you can't add a new option yourself that will do what you need. As well as all the classes being sealed & obfuscated, there's some internal infrastructure that has to be updated when new options are added.
A workaround you can use, if you are using the SDK, is to write your own state machine that parses the object text in the relevant Text property if the objects aren't equal, and determines if the only difference is the WITH ENCRYPTION property missing in one.
Simon C / comments
Unfortunately, you can't add a new option yourself that will do what you need. As well as all the classes being sealed & obfuscated, there's some internal infrastructure that has to be updated when...
I can confirm that this issue has been fixed in the 8.0.1 patch release. More details are available here. Please use Check for Updates from the Help menu to download it
Simon C / comments
I can confirm that this issue has been fixed in the 8.0.1 patch release. More details are available here. Please use Check for Updates from the Help menu to download it
Simon C
Hi LittleColin. Thanks for the bug report - I've managed to reproduce it on my machine. We'll be getting a patch release out ASAP to fix this. Apologies for the problems this causes
Simon / comments
Hi LittleColin. Thanks for the bug report - I've managed to reproduce it on my machine. We'll be getting a patch release out ASAP to fix this. Apologies for the problems this causes
Simon