Applies to ApexSQL Diff
Summary This article explains the ApexSQL Diff CLI switches, and their usage through the examples
Description
Connection switches
/server1 | Specifies server and instance name of the source SQL instance Alias: /s1 Format: /server1:server_name[\instance_name] |
/server2 | Specifies server and instance name of the destination SQL instance Alias: /s2 Format: /server2:server_name[\instance_name] |
| Quick tip: If a server is not specified "(local)" instance is assumed. |
/database1 | Specifies the name of the source database Alias: /d1 Format: /database1:SourceDatabaseName |
/database2 | Specifies the name of the destination database Alias: /d2 Format: /database2:DestinationDatabaseName |
/user1 | Specifies the source login when using SQL Server authentication Alias: /u1 Format: /user1:sourcelogin Note: You must use this option together with the /password1 switch |
/user2 | Specifies the destination login when using SQL Server authentication Alias: /u2 Format: /user2:destinationlogin Note: You must use this option together with the /password2 switch |
| Quick tip: If a user is not specified a trusted connection is assumed |
/password1 | Specifies the source login's password when using SQL Server authentication Alias: /p1 Format: /password1:sourcepassword Note: You must use this option together with the /user1 switch |
/password2 | Specifies the destination login's password when using SQL Server authentication Alias: /p2 Format: /password2:destinationpassword Note: You must use this option together with the /user2 switch |
/backup1 | Specifies the file name of the source backup Alias: /b1 Format: /backup1:”SourceBackup.bak” |
/backup2 | Specifies the file name of the destination backup
Alias: /b2
Format: /backup2: ”DestinationBackup.bak” |
/backup_set1 | Specifies the file name of the source differential backup set
Alias: /bs1
Format: /backup_set1: SourceBackupSetName |
/backup_set2 | Specifies the file name of the destination differential backup set
Alias: /bs2
Format: backup_set2: DestinationBackupSetName |
| Quick tip: The full path of a backup file, along with the backup file extension, e.g. .bak, or .trn, has to be defined, so that command could be correct. |
/snapshot1 | Specifies the file name of the source snapshot
Alias: /sn1
Format: /snapshot1: ”SourceSnapshot.axsnp” |
/snapshot2 | Specifies the file name of the destination snapshot
Alias: /sn2
Format: /snapshot2: ”DestinationSnapshot.axsnp” |
/sourcecontrol_ folder1 | Specifies the path of the local working folder as the source Alias: /scf1 Format: /sourcecontrol_folder1:”SourceControlFolder Source” |
/sourcecontrol_ folder2 | Specifies the path of the local working folder as the destination Alias: /scf2 Format: /sourcecontrol_folder2:"SourceControlFolder Destination” |
/sourcecontrol_ type1 | Specifies the source control system to be compared as the source:
|
/sourcecontrol_ type2 | Specifies the source control system to be compared as the destination:
mercurial Note: These arguments can’t be combined |
/sourcecontrol_ server1 | Specifies the name of the source control server used as the source (TFS server, Perforce host) Alias: /scs1 Format: /sourcecontrol_server1:[<protocol>://<hostname>:<portname>/tfs | https://.visualstudio.com/DefaultCollection] (example for Team Foundation Server) Format: /sourcecontrol_server1:<protocol>://<hostname>:<portname> (example for Perforce) |
/sourcecontrol_ server2 | Specifies the name of the source control server used as the destination (TFS server, Perforce host) Alias: /scs2 Format: /sourcecontrol_server2:[<protocol>://<hostname>:<portname>/tfs | https://.visualstudio.com/DefaultCollection] (example for Team Foundation Server) Format: /sourcecontrol_server2:<protocol>://<hostname>:<portname> (example for Perforce) |
/sourcecontrol_ repository1 | Specifies the repository of the source control server used as the source(Git, Mercurial, Subversion repository, Perforce depot) Alias: /scr1 Format: /sourcecontrol_repository1: <protocol>://<hostname>:<portnumber>/<git_server_name> /<repository> (example for Git repository) Format: /sourcecontrol_repository1:<protocol> ://<hostname>:<portnumber>/<repository>/ (example for Mercurial repository) Format: /sourcecontrol_repository1:<protocol> ://<hostname>:<portnumber>/svn/ <repository>/ (example for Subversion repository) |
/sourcecontrol_ repository2 | Specifies the repository of the source control server used as the destination (Git, Mercurial, Subversion repository, Perforce depot) Alias: /scr2 Format: /sourcecontrol_repository2:<protocol> ://<hostname>:<portnumber>/<git_server_name>/<repository> (example for Git repository) Format: /sourcecontrol_repository2:<protocol>://<hostname>:<portnumber>/<repository> (example for Mercurial repository) Format: /sourcecontrol_repository2:<protocol> ://<hostname>:<portnumber>/svn/<repository>/ (example for Subversion repository) |
/sourcecontrol_ user1 | The login used to connect to the source control server used as the source Alias: /scu1 Format: /sourcecontrol_user1:sourcelogin |
/sourcecontrol_ user2 | The login used to connect to the source control server used as the destination Alias: /scu2 Format: /sourcecontrol_user2:destinationlogin |
/sourcecontrol_ password1 | Specifies the password for the login used as the source /sourcecontrol_user1 Alias: /scp1 Format: /sourcecontrol_password1: sourcepassword |
/sourcecontrol_ password2 | Specifies the password for the login used as the destination/sourcecontrol_user2 Alias: /scp2 Format: /sourcecontrol_password2: destinationpassword |
/sourcecontrol_ branch1 | Specified the branch name for the Git source control type used as the source ("master" if omitted)
Alias: /scb1
Format: /sourcecontrol_branch1: "source_branch_name" |
/sourcecontrol_ branch2 | Specified the branch name for the Git source control type used as the destination ("master" if omitted)
Alias: /scb2
Format: /sourcecontrol_branch2: "destination_branch_name" |
/sourcecontrol_ project1 | Project path containing script files on the source control server used as the source (Git, Mercurial, Subversion, TFS folder, Perforce workspace) Alias: /scj1 Format: /sourcecontrol_project1:"$/ProjectName" |
/sourcecontrol_ project2 | Project path containing script files on the source control server used as the destination (Git, Mercurial, Subversion, TFS folder, Perforce workspace) Alias: /scj2 Format: /sourcecontrol_project2:"$/ProjectName" |
/get_sources_by_ label_1 | Gets the script files from the source control used as the comparison source by label
Alias: /scl1
Format: /get_sources_by_label_1: "SourceLabelName" Note: Omitting this switch will result in getting the latest label |
/get_sources_by_ label_2 | Gets the script files from the source control used as the comparison destination by label
Alias: /scl2
Format: /get_sources_by_label_2: "DestinationLabelName" Note: Omitting this switch will result in getting the latest label |
/script_folder1 | Specifies the path of the script folder to be used as the source
Alias: /sf1
Format: /script_folder1: ”SourceScriptFolder” |
/script_folder2 | Specifies the path of the script folder to be used as the destination
Alias: /sf2
Format: /script_folder2: ”DestinationScriptFolder” |
/collation1 | Specifies the SQL compatibility level of the scripts in the source script folder or source control Alias: /c1 Default: SQL_Latin1_General_CP1_CI_AS Format: /collation1:collation_constant |
/collation2 | Specifies the SQL compatibility level of the scripts in the destination script folder or source control Alias: /c2 Default:SQL_Latin1_General_CP1_CI_AS Format: /collation2:collation_constant |
/compatibility_ level1 | Specifies the SQL compatibility level of the scripts in the source script folder or source control:
|
/compatibility_ level2 | Specifies the SQL compatibility level of the scripts in the destination script folder or source control:
|
Integration services connection switches
/integration_ services_ packages1 | Integration services packages used as the source data source Alias: /isp1 Format: |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center