How can we help you today? How can we help you today?

How do I get command line to respect exclude arguments?

Based on the documentation for SQL Compare command line it seems I should be able to do this:

sqlcompare /Include:identical /exclude:assembly /Scripts1:'C:\TeamCity\buildAgent\work\c0ebf743024d92d6\trunk\Database\Databases\Intranet' /Server2:MYSERVER /Database2:Intranet

but the exclude switches seem to do nothing. The output clearly compares the assemblies anyway. I got

/exclude user

to work, but not role or assembly. Suggestions?
freecell1
0

Comments

2 comments

Sort by
  • peter.peart
    Thanks for your post. I suspect that the assembly is being pulled in because of a dependency. You'd need to, as far as I am aware, specify all the options you did want manually and not specify to include dependencies.

    HTH!

    Pete
    peter.peart
    0
  • freecell1
    I figured it out. It looks like the /include:identical switch overrides /exclude switches, because when I took the include out it worked as expected.

    This isn't the behavior I'd expect to see. I would think that

    /include:identical /exclude:assembly /exclude:role

    for example, would first exclude all roles and assemblies, and then produce a report of the remaining object types including identical ones. That's not how it works though ... I tried

    /include:identical /exclude:role

    to take assembly-related concerns out of the test, and it output a list that included roles ...
    freecell1
    0

Add comment

Please sign in to leave a comment.