Activity overview
Latest activity by RobVK
Using migration scripts from command line on unlinked DB
We're using SQL Compare 9 with SQL Source Control at the moment to deploy some of our databases using NAnt. The way it currently works is everyone commits using SQL Source Control, and on the build...
I think I may have solved it, or at least my problem.
My problem was that my live system had different users to my dev systems and role members were thus different. All permissions on objects were set to roles. The default settings were trying to remove the extra users and remove them from the roles.
The following switches allow me to do this:
SQLCompare.exe
/src1:<folder path>
/server2:myserver
/db2:some_db
/options:default,IgnoreUsers
/exclude:Users
/scriptfile:myscript.sql
The ones I changed to get this to work properly are /exclude and /options.
Hope that helps! / comments
I think I may have solved it, or at least my problem.
My problem was that my live system had different users to my dev systems and role members were thus different. All permissions on objects were ...
I have a similar problem where I need to exclude syncing of a specific type of object.
The examples use the /exclude switch and mention a table setting for it (/exclude:table) which excludes all tables. Are there any settings for other objects? If so is there a complete list somewhere? / comments
I have a similar problem where I need to exclude syncing of a specific type of object.
The examples use the /exclude switch and mention a table setting for it (/exclude:table) which excludes all ta...