Posts
Sort by recent activity
detecting create vs alter differences
We are using SQLCompare to compare against a database and scripts folder.
In our scripts for for objects such as Stored procedures, views, functions, we currently use the "IF NOT EXIST... create ob...
Cannot load VDM IPX/SPX support
I am using the command line APIs to invoke SQL compare.
Sometimes, in the console, I get the error message
"Cannot load VDM IPX/SPX support"
However, everything seems to run fine.
I am using Powers...
Comparing with COLLATION against scripts folder
When comparing with collations turned ON,
The database by default has SQL_Latin1_General_CP1_CI_AS
the scripts in the script folder do NOT specify collation at all
SqlCompare 6.2 complains about a ...
scriptfile generation to syncronize db from scripts folder
I am using the command line and the argument /scriptfile to create a single generated script.
Is it possible to generate multiple script files instead of one long concatenated set of differences?
I...
excluding #temp tables from comparison via scripts
I am evaluating SQL Compare at the moment, and am trying to compare scripts in a folder to a database.
We have many stored procedures, and developers often create and temp tables within the stored ...