CompareWith Method and options Enums in VS2003 Project
Disciple1991
Posts: 4
I am using the CompareWith method to return a Differences object in a .NET Windows Forms application.
I am using the Options.IgnorePermissions enum for the Differences object but one of the tables still displays as a difference because the permissions are different for the Table between db1 and db2.
e.g. coDatabaseSource.CompareWith(coDatabaseTarget, Options.IgnorePermissions)
Is there another enum I should be using to ignore Permissions on Tables when using the RedGate.SQLCompare.Engine dll?
I am using the Options.IgnorePermissions enum for the Differences object but one of the tables still displays as a difference because the permissions are different for the Table between db1 and db2.
e.g. coDatabaseSource.CompareWith(coDatabaseTarget, Options.IgnorePermissions)
Is there another enum I should be using to ignore Permissions on Tables when using the RedGate.SQLCompare.Engine dll?
Comments
Have you remembered to also feed the options enumeration (Options.IgnorePermissions) to the BuildFromDifferences method? You have to specify the comparison options in both places if you want the resulting script to be correct.
Hopefully this solves the problem.