How can we help you today? How can we help you today?

sql compare command line - set source directly to SVN?

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!
jhilden
0

Comments

4 comments

  • 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
    Manfred.Castro
    0
  • jhilden
    is /scriptsfolderxml still available in the newest version of SQL Compare? I just tried and it says that the arg is not valid.
    jhilden
    0
  • 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.
    Manfred.Castro
    0
  • jhilden
    Thanks Manfred, I had 10.0 installed. With 10.1 I get that option.
    jhilden
    0

Add comment

Please sign in to leave a comment.