| Author |
Message |
johnreynolds
Joined: 15 Sep 2012
Posts: 2
|
 Posted: Sat Sep 15, 2012 1:31 am Post subject: Command Line /Project ignores .scp settings |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Mon Sep 17, 2012 9:17 am Post subject: |
|
|
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. |
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
johnreynolds
Joined: 15 Sep 2012
Posts: 2
|
| Posted: Mon Sep 17, 2012 6:37 pm Post subject: |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Tue Sep 18, 2012 9:11 am Post subject: |
|
|
Sorry for the misunderstanding. I'll see if I can figure out what's gone wrong with SQL Compare.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Tue Sep 18, 2012 9:40 am Post subject: |
|
|
Thanks for reporting this. I have logged a bug, SC-6040. SQL Compare is not behaving as it should with regard to saved selections.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Fri Sep 28, 2012 4:42 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
|
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
