Comments
Sort by recent activity
I would also like to see this feature added as I often get caught out by this as well. / comments
I would also like to see this feature added as I often get caught out by this as well.
Hi. I think you can do this by using the /export:<directory> (or /e) command line option. / comments
Hi. I think you can do this by using the /export:<directory> (or /e) command line option.
Sorry!. i should have realised with the .sdc file extension that you referred to.
you can still get the options from the command line using:
SQLDataCompare.exe /?
or
SQLDataCompare.exe /v /?
Here is an example command line with data compare that we used to use to sync the data. I did find it initially a bit fiddly to get working, hence the extra options. You may not need these depending on your schema.
.\sqldatacompare /scr1:"C:\CI\Sql Server\Databases\Production" /s2:SqlSvr /DB2:MyDb /sync /o:d /o:fc /o:t /o:k /f
You could use a project file and specify the name of it with the /pr option e.g. sqldatacompare /pr:"myproject.sdc", but I've never done that and elected to do it all through the options available in the command line.
the critical parameter is the /sync option which is what forces it to perform the update.
hope this helps. / comments
Sorry!. i should have realised with the .sdc file extension that you referred to.
you can still get the options from the command line using:
SQLDataCompare.exe /?
or
SQLDataCompare.exe /v /?
Here i...