sql compare command line - set source directly to SVN?

jhilden

I'm evaluating SQL Source Control and SQL compare, I'm using the following command to compare:

sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /verbose /sync

I understand that SQL Compare looks at the extended properties of db1 to look up the source control info. That seems to work really well. I'm wondering if it would be possible to specify the source control info directly from the command line (i.e. https://svn.foo.com/trunk/...).

The practical application of this is that my development DB might be pointing to the the trunk of source control but I want to sync against a tag in source control.

As I understand it, my current work around is to un-link dev from trunk, and re-link it to my tag. That will work ok, but I like the idea of specifying the full source control path explicitly.

Thanks guys, great product!

Manfred.Castro

This would be considered a feature request. You can submit the feature request to our user voice forum. If you request recieves enough votes our development team may add the feature to the a future release.
http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions

edit:
It *is* possible to specify this using /scriptsfolderxml. It involves copying the contents of the scripts folder extended property and referencing this using /scriptsfolderxml.
http://www.red-gate.com/messageboard/viewtopic.php?t=15011

jhilden

is /scriptsfolderxml still available in the newest version of SQL Compare? I just tried and it says that the arg is not valid.

Manfred.Castro

Yes, It is a new feature as of 10.1 I believe.

/scriptsfolderxml:<scriptsfolderxml> (Alias: /sfx)
[Deprecated] A file containing the script folder location XML fragment.

jhilden

Thanks Manfred, I had 10.0 installed. With 10.1 I get that option.