This topic describes the CLI-powered access to the functionality of dbForge Data Compare installed into a CrossOver bottle. For more information on the command-line functionality of dbForge Data Compare, refer to the corresponding topics of the documentation.
As an example, let’s see how to launch data comparison. To do that, run the following command:
"/opt/cxoffice/bin/wine" --bottle "dbForge_Data_Compare" --check --wait-children --start "C:/Program Files/Devart/Compare Bundle for SQL Server/dbForge Data Compare for SQL Server/datacompare.com" /datacompare /source connection:"Data Source=[host];Initial Catalog=[database];Integrated Security=False;User ID=[yourusername];Password=[yourpassword]" /target connection:"Data Source=[host];Initial Catalog=[database];Integrated Security=False;User ID=[yourusername];Password=[yourpassword]" /sync
Where:
Let us look at a worked example command to launch data comparison of the AdventureWorks2019 databases that resides on different servers.
"/opt/cxoffice/bin/wine" --bottle "dbForge_Data_Compare" --check --wait-children --start "C:/Program Files/Devart/Compare Bundle for SQL Server/dbForge Data Compare for SQL Server/datacompare.com" /datacompare /source connection:"Data Source=demo-mssql\SQLEXPRESS;Initial Catalog=AdventureWorks2019;Integrated Security=False;User ID=yourusername;Password=yourpassword" /target connection:"Data Source=DBFSQLSRV\SQL2019;Initial Catalog=AdventureWorks2019;Integrated Security=False;User ID=yourusername;Password=yourpassword" /sync