Command Line /Project ignores .scp settings

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

Command Line /Project ignores .scp settings

Postby johnreynolds » Sat Sep 15, 2012 1:31 am

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?
johnreynolds
 
Posts: 2
Joined: Sat Sep 15, 2012 1:24 am

Postby Brian Donahue » Mon Sep 17, 2012 9:17 am

It sounds like everything is working as designed. It says this is true in the documentation at http://www.red-gate.com/supportcenter/C ... _in_the_cl
•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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby johnreynolds » Mon Sep 17, 2012 6:37 pm

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?
johnreynolds
 
Posts: 2
Joined: Sat Sep 15, 2012 1:24 am

Postby Brian Donahue » Tue Sep 18, 2012 9:11 am

Sorry for the misunderstanding. I'll see if I can figure out what's gone wrong with SQL Compare.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Tue Sep 18, 2012 9:40 am

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

Postby Brian Donahue » Fri Sep 28, 2012 4:42 pm

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

It is designed to fix this problem with the command-line, but may well cause additional harm.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu Apr 24, 2014 8:27 am

This issue is fixed in the latest SQL Compare 10.7.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest