Activity overview
Latest activity by david.proctor
Like Brian says, your best option is probably to check the scripts out and run a command like the following: SQLCompare.exe /scripts1:"C:\ScriptsFolder" /s2:targetserver /db2:targetdatabase /include:staticdata /sync
However, you can also get SQL Compare to check it out of SQL Source Control for you using the
/version1
switch. Using
/version1:HEAD
checks out the most recent copy of the database. SQLCompare.exe /s1:sourceserver /db1:SourceDatabase /version1:HEAD /s2:targetserver /db2:targetdatabase /include:staticdata /sync
Just to be clear, it doesn't actually compare against the source database, it compares against the scripts folder of the source database that it checks out.
To store the data as well as the schema you'll want to make sure you've linked all the tables as static data. More about this is here: http://www.red-gate.com/supportcenter/c ... lling_Data
Let me know if this is useful and if you need any more help. / comments
Like Brian says, your best option is probably to check the scripts out and run a command like the following:SQLCompare.exe /scripts1:"C:\ScriptsFolder" /s2:targetserver /db2:targetdatabase /include...
Hi,
Did you have any other problems at all or did the web article cover it all?
I was setting it up for Team Foundation Service recently and I had to append '/defaultcollection' to the url to make it work whereas that wasn't necessary for TFSpreview. / comments
Hi,
Did you have any other problems at all or did the web article cover it all?
I was setting it up for Team Foundation Service recently and I had to append '/defaultcollection' to the url to make ...