Red Gate forums :: View topic - Command Line /Project ignores .scp settings
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

Command Line /Project ignores .scp settings

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



Joined: 15 Sep 2012
Posts: 2

PostPosted: Sat Sep 15, 2012 1:31 am    Post subject: Command Line /Project ignores .scp settings Reply with quote

I have a .scp file that has a handful of objects out of a few hundred specified for sync.
Running from the Deployment wizard (SQL Compare UI) generates the correct script (only the objects i selected).
Using the /Project option at the command line generates scripts for all objects. (i only used the /Project switch, no other switches)

Sorry if this question has already been answered, but i did some searches and couldnt find an answer

Thoughts?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Sep 17, 2012 9:17 am    Post subject: Reply with quote

It sounds like everything is working as designed. It says this is true in the documentation at http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/sc_cl_Switches_in_the_cl
Quote:
•When you use the command line, your project option selections are ignored and the defaults are used. Use /Options to specify any additional options you want to use with a command line project.
Back to top
View user's profile Send private message
johnreynolds



Joined: 15 Sep 2012
Posts: 2

PostPosted: Mon Sep 17, 2012 6:37 pm    Post subject: Reply with quote

I'm not referring to the /Options switch, I'm talking about the actual selected objects (table / sprocs).
which in the previous bullet point in the documentation:

"When you use a project, all objects that were selected for comparison when you saved the project are automatically included."

Especially since you cant use include/exclude with the /project switch, it would seem that the selected objects should be picked up from the scp.

What would be the point of being able to specify a project file at the command line if nothing is actually used from the file?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Tue Sep 18, 2012 9:11 am    Post subject: Reply with quote

Sorry for the misunderstanding. I'll see if I can figure out what's gone wrong with SQL Compare.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Tue Sep 18, 2012 9:40 am    Post subject: Reply with quote

Thanks for reporting this. I have logged a bug, SC-6040. SQL Compare is not behaving as it should with regard to saved selections.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Fri Sep 28, 2012 4:42 pm    Post subject: Reply with quote

There is a very-beta patch to SQL Compare out now, if you want to try it:
ftp://support.red-gate.com/patches/sql_compare/sql_compare_10.2.0.1647.zip

It is designed to fix this problem with the command-line, but may well cause additional harm.
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