The executable package that runs on the client machine supports the following command line arguments:
| /? or /help | Print the command line help screen |
| /q[uiet] | Indicates the quite mode which suppresses all messages from being displayed on the screen. |
| /c[onfig]:<ConfigFile> | Specifies the configuration file that overwrites the package's settings. If a configuration file is found, the command line arguments are ignored except of the /q option. The configuration files supported via command line are xml files that can be generated using xSQL Builder configuration interface. |
| /s[erver]:<name> | Specifies the name of the destination Sql Server. |
| /d[atabase]:<name> | Specifies the name of the destination database. |
| /u[sername]:<value> | Specifies the username that should be used to connect to the destination database. |
| /p[assword]:<value> | Specifies the password that should be used to connect to the destination database. |
| /t[rusted]:<true|false> | Indicates that connection to the destination database should be established using trusted connection; username and password options are ignored. |
| /pr[esync]:<script> | The T-SQL scripts that should be executed before comparing and synchronizing the database schemas. |
| /prtype:<file|folder> | Indicates the type of the pre-sync script as file or folder. If the folder option is specified, all the files with .sql extension in that folder will be executed in alphabetical order. |
| /po[stsync]:<script> | The T-SQL scripts that should be executed after synchronizing the database schemas. |
| /potype:<file|folder> | Indicates the type of the post-sync scripts as file or folder. If the folder option is specified, all the files with .sql extension in that folder will be executed in alphabetical order. |
The command line arguments can be inspected in the code template provided with xSQL builder. Note that command line options overwrite settings defined when the package was configured and built. If the value of a command line parameter contains spaces it must be enclosed in double quotes.