Comments
Sort by recent activity
/scriptencoding is the command line switch you're looking for - see the docs for more details. / comments
/scriptencoding is the command line switch you're looking for - see the docs for more details.
You can switch to a different text encoding for your script to avoid the byte order marker problem - if you're just saving the script from a synchronization in the UI, the setting is in Application Options, accessible from the Tools menu. / comments
You can switch to a different text encoding for your script to avoid the byte order marker problem - if you're just saving the script from a synchronization in the UI, the setting is in Application...
If you bring up the project list (close the project configuration dialog, press the folder button on the toolbar) then there is a check box at the bottom of the dialog, labelled 'Show this screen on startup', which you can select to tell SQL Compare to start with the project list rather than the last open project.
Does that help? / comments
If you bring up the project list (close the project configuration dialog, press the folder button on the toolbar) then there is a check box at the bottom of the dialog, labelled 'Show this screen o...
Comparisons with backup files don't support custom comparison keys. You can use any index on the table as a comparison key, but you can't use columns or combinations of columns which aren't the column list of an index. If you want to use your guid column as a comparison key, you will have to create an index on the column before doing the backup.
Differential backup files should work fine as long as the corresponding full backup file is also included in the backup file list. / comments
Comparisons with backup files don't support custom comparison keys. You can use any index on the table as a comparison key, but you can't use columns or combinations of columns which aren't the col...
The two most likely causes of 6.2 hanging are:
1) Network printers that aren't currently attached - the DevExpress controls we use look for printers during their initialization and can sometimes hang if they can't contact some of the installed printers.
2) Project files with network locations that no longer exist - occasionally it will take a very long time to determine whether a path exists or not and might get stuck altogether. Try moving the contents of the project directory out to another directory temporarily. / comments
The two most likely causes of 6.2 hanging are:
1) Network printers that aren't currently attached - the DevExpress controls we use look for printers during their initialization and can sometimes ha...
Yes, and yes - it's fixed in 8.0. / comments
Yes, and yes - it's fixed in 8.0.
It's basically what happens to UI components when an exception manages to propogate into them and breaks things until they can't display anything meaningful any more.
So any unexpected exception that gets thrown can do this to .NET applications, if it gets thrown in an unfortunate place (OutOfMemoryException is a common culprit as it can show up almost anywhere; NullReferenceException is also often the proximate cause due to another thread failing and not setting values correctly). / comments
It's basically what happens to UI components when an exception manages to propogate into them and breaks things until they can't display anything meaningful any more.
So any unexpected exception th...
The switches you're looking for are /server1: and /server2: (or /s1: and /s2:). So your command line would look like the following:
sqldatacompare /server1:SERVERNAME /db1:WidgetStaging /server2:SERVERNAME /db2:WidgetProduction /ScriptFile:"C:\Scripts Folder\WidgetSyncScript.sql" / comments
The switches you're looking for are /server1: and /server2: (or /s1: and /s2:). So your command line would look like the following:
sqldatacompare /server1:SERVERNAME /db1:WidgetStaging /server2:SE...
You can get an error like this if you have a partial script folder which has objects that rely on a table (e.g. indexes, triggers, foreign keys) that don't have a corresponding table. SQL Compare only handles script folders with complete objects - incomplete objects will cause problems. / comments
You can get an error like this if you have a partial script folder which has objects that rely on a table (e.g. indexes, triggers, foreign keys) that don't have a corresponding table. SQL Compare o...
Currently the easiest thing to do is probably edit the project in the UI and save under a different name each server/database combination you need.
If you need to do the editing automatically, your best bet is going to be using an xml argfile instead of a project - then you can have your program produce argfiles based on the baseline argfile when you need to change server details.
I've logged the request to override specific parts of the project settings from the command line as a feature request - SC-4520 - but obviously it'll be a while before we get around to it if we implement it at all. / comments
Currently the easiest thing to do is probably edit the project in the UI and save under a different name each server/database combination you need.
If you need to do the editing automatically, your...