Comparing Users and Roles
Daniel Handley
Posts: 214
When you use SQL Compare to make a comparison of two databases it will initially include all objects contained within the databases.
This is primarily because if items were filtered out dependencies may be missed, and at worst the synchronization could corrupt a database.
Because of this there is no way to exclude an object from the initial compare.
Once you have compared the databases, as you have found, it is possible to filter out certain object types as required.
However if you have the SQL toolkit, and use the command line tool, it is possible to include or exclude objects as required.
For further information about the SQL toolkit please take a look at the SQL tools product page on our web site. There is a SQL toolkit help file that includes all the command line option available to use. This help file is installed as part of the SQL bundle, or you can download it from our web site.
Regards
Dan
This is primarily because if items were filtered out dependencies may be missed, and at worst the synchronization could corrupt a database.
Because of this there is no way to exclude an object from the initial compare.
Once you have compared the databases, as you have found, it is possible to filter out certain object types as required.
However if you have the SQL toolkit, and use the command line tool, it is possible to include or exclude objects as required.
For further information about the SQL toolkit please take a look at the SQL tools product page on our web site. There is a SQL toolkit help file that includes all the command line option available to use. This help file is installed as part of the SQL bundle, or you can download it from our web site.
Regards
Dan
Daniel Handley
Red Gate Software Ltd
Red Gate Software Ltd
This discussion has been closed.
