Red Gate forums :: View topic - Can't exclude dependencies when running from command line
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Can't exclude dependencies when running from command line

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Duns79



Joined: 19 Oct 2012
Posts: 5

PostPosted: Fri Oct 19, 2012 6:27 am    Post subject: Can't exclude dependencies when running from command line Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Mon Oct 22, 2012 4:48 pm    Post subject: Reply with quote

Can you please try this build of SQL Compare?
ftp://support.red-gate.com/patches/SQL_Compare/SQL_Compare_10.2.0.1647.zip

There are some problems with 10.2.0.1337 with regard to the way the command-line processes options.
Back to top
View user's profile Send private message
Duns79



Joined: 19 Oct 2012
Posts: 5

PostPosted: Mon Oct 22, 2012 11:45 pm    Post subject: Reply with quote

Hi Brian,

I have loaded that version but it doesn't seem to have made any difference.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Tue Oct 23, 2012 9:02 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Duns79



Joined: 19 Oct 2012
Posts: 5

PostPosted: Tue Oct 23, 2012 11:34 pm    Post subject: Reply with quote

I can create a zip file that contains the two databases and the SQL Compare project file. How should I upload this to you?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Wed Oct 24, 2012 10:48 am    Post subject: Reply with quote

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

Thanks!
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Fri Oct 26, 2012 10:38 am    Post subject: Reply with quote

I forgot to give you the address... it's support@red-gate.com.
Back to top
View user's profile Send private message
Duns79



Joined: 19 Oct 2012
Posts: 5

PostPosted: Wed Oct 31, 2012 11:14 pm    Post subject: Reply with quote

Brian

I have uploaded the files to the FTP site you provided

Thanks
David
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Tue Feb 19, 2013 11:15 am    Post subject: Reply with quote

I've retested this issue and it appears to be fixed in SQL Compare 10.2.6.
Back to top
View user's profile Send private message
Duns79



Joined: 19 Oct 2012
Posts: 5

PostPosted: Wed Feb 20, 2013 5:30 am    Post subject: Reply with quote

Hi Brian,

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

Thanks for following up.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group