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

Can't exclude dependencies when running from command line

I am trying to compare two databases using the following parameters

/Project:SomeProject.scp /ScriptFile:SomeScript.sql /Force /Options:DecryptPost2KEncryptedObjects,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreFileGroups,IgnoreUserProperties,IgnoreWithElementOrder,IgnoreDatabaseAndServerName

but it still includes the dependencies that are picked up when comparing the databases and saving them to the script file.

Even when running with /Options:None I still get the same output.

If I run the same project through the UI I can unselect the Deploy All Dependencies check box and I get the script as I would expect.

Is there any way to do this through the command line?

I am running 10.2.0.1337 of SQL Compare.

Thanks
Duns79
0

Comments

9 comments

  • Brian Donahue
    Can you please try this build of SQL Compare?
    ftp://support.red-gate.com/patches/SQL_ ... 0.1647.zip

    There are some problems with 10.2.0.1337 with regard to the way the command-line processes options.
    Brian Donahue
    0
  • Duns79
    Hi Brian,

    I have loaded that version but it doesn't seem to have made any difference.
    Duns79
    0
  • Brian Donahue
    Sorry, there isn't any feedback that the program gives that can help. We'll need the project and the databases to try to reproduce the problem.
    Brian Donahue
    0
  • Duns79
    I can create a zip file that contains the two databases and the SQL Compare project file. How should I upload this to you?
    Duns79
    0
  • Brian Donahue
    Can you attach what you've got to an email and quote F0065890 in the email subject line?

    Thanks!
    Brian Donahue
    0
  • Brian Donahue
    I forgot to give you the address... it's support@red-gate.com.
    Brian Donahue
    0
  • Duns79
    Brian

    I have uploaded the files to the FTP site you provided

    Thanks
    David
    Duns79
    0
  • Brian Donahue
    I've retested this issue and it appears to be fixed in SQL Compare 10.2.6.
    Brian Donahue
    0
  • Duns79
    Hi Brian,

    I have retested on version 10.2.6 and the problem now seems to be resolved.

    Thanks for following up.
    Duns79
    0

Add comment

Please sign in to leave a comment.