Activity overview
Latest activity by rchan
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 ...
I'm looking for flexibilty in creating the script file.
For example, developers do not control (or own) user roles and permissions on objects. It would be nice, for example, if when doing script - db synchronization, that all the users/roles/permissions could be scripted in its own files, while each stored procedure difference be scripted in its own file, etc.
But yes, it looks like I will have to use SQL Compare to generate a list of differences, and then use my own scripting tools to copy the scripts to form my own deployment package to install on the database. Thanks. / comments
I'm looking for flexibilty in creating the script file.
For example, developers do not control (or own) user roles and permissions on objects. It would be nice, for example, if when doing script - ...
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 ...