Can't exclude dependencies when running from command line

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Can't exclude dependencies when running from command line

Postby Duns79 » Fri Oct 19, 2012 6:27 am

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
 
Posts: 5
Joined: Fri Oct 19, 2012 6:17 am

Postby Brian Donahue » Mon Oct 22, 2012 4:48 pm

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Duns79 » Mon Oct 22, 2012 11:45 pm

Hi Brian,

I have loaded that version but it doesn't seem to have made any difference.
Duns79
 
Posts: 5
Joined: Fri Oct 19, 2012 6:17 am

Postby Brian Donahue » Tue Oct 23, 2012 9:02 am

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Duns79 » Tue Oct 23, 2012 11:34 pm

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
 
Posts: 5
Joined: Fri Oct 19, 2012 6:17 am

Postby Brian Donahue » Wed Oct 24, 2012 10:48 am

Can you attach what you've got to an email and quote F0065890 in the email subject line?

Thanks!
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Fri Oct 26, 2012 10:38 am

I forgot to give you the address... it's support@red-gate.com.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Duns79 » Wed Oct 31, 2012 11:14 pm

Brian

I have uploaded the files to the FTP site you provided

Thanks
David
Duns79
 
Posts: 5
Joined: Fri Oct 19, 2012 6:17 am

Postby Brian Donahue » Tue Feb 19, 2013 11:15 am

I've retested this issue and it appears to be fixed in SQL Compare 10.2.6.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby Duns79 » Wed Feb 20, 2013 5:30 am

Hi Brian,

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

Thanks for following up.
Duns79
 
Posts: 5
Joined: Fri Oct 19, 2012 6:17 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 2 guests