Comments
Sort by recent activity
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...
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 ...