How to use a project file in the CLI (4211094)

Applies to
ApexSQL Data Diff, ApexSQL Diff, ApexSQL Doc, ApexSQL Log, ApexSQL Script, ApexSQL Trigger

Summary
This article explains how to use a project file in the CLI.

Applies to
ApexSQL Data Diff, ApexSQL Diff, ApexSQL Doc, ApexSQL Log, ApexSQL Script, ApexSQL Trigger

Summary
This article explains how to use a project file in the CLI.

Description
Instead of setting the value of switches directly in the CLI, setting up a project file through the GUI with the desired options pre-set, saves time, because it requires only one switch to be used in the CLI.

Creating a project file
In this example we’ll use ApexSQL Data Diff, but for other products it is similar. Run ApexSQL Data Diff and open the New project dialog, from the Home tab in the top menu.

After setting up the source and destination, various comparison and synchronization options can be set. Furthermore, objects could be filtered and mapped, depending on the user preferred options:

When all options are set, the project can be saved by clicking on the Save button, in the bottom left corner of the New project dialog.

Name the project and set the path where it will be saved, in this example it’s saved to C:\Users\UserName\Desktop\Projects\DataSync.axdd

Quick tip: If any of the folders, used in the project’s path, has spaces in its name, double quotation marks must be used for the whole path of the project file in order to be loaded successfully Extensions: ApexSQL Data Diff: .axdd ApexSQL Diff: .axds ApexSQL Doc: .axdp ApexSQL Log: .axlp ApexSQL Script: .axsc ApexSQL Trigger: .axap Quick tip: Specified settings saved in the project file can be overridden if you add the appropriate switch, without the need to change the project file itself Top FAQs about using the project file in the CLI Q: Can the same project file be used in all ApexSQL applications? A: No, because each application has some settings that are specific only for it, and they cannot be used in other ApexSQL applications. The difference is made with specific extensions of the Project file for each application as listed above in the article. Q: Can the Project file be modified? A: Yes. The project file can be modified from the GUI and then saved with the changes made to replace the existing project file or under a new name.