CompareWith Method and options Enums in VS2003 Project

Disciple1991Disciple1991 Posts: 4
edited February 22, 2006 8:17AM in SQL Toolkit Previous Versions
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?

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello Grant,

    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.
Sign In or Register to comment.