Command-Line Mode on macOS
You can use Terminal to run dbForge Studio for Oracle on a Mac.
Note
This topic describes the CLI-powered access to the functionality of dbForge Studio installed into a CrossOver bottle. For more information on the command-line functionality of the Studio, refer to the corresponding topics of the documentation.
As an example, let’s see how to compare the data of two databases from Terminal. To do that, run the following command:
/Applications/CrossOver.app/Contents/SharedSupport/CrossOver/bin/wine --bottle 'dbForge_Studio_Oracle' --check --wait-children --start "C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com" /datacompare /source connection:"User Id=[yourusername];Password=[yourpassword];Server=[X.X.X.X];Connect Mode=SysDba;Unicode=True;Pooling=False;Direct=True;Service Name=[service_name];Enlist=False;Transaction Scope Local=True" /target connection:"User Id=[yourusername];Password=[yourpassword];Server=[X.X.X.X];Connect Mode=SysDba;Unicode=True;Pooling=False;Direct=True;Service Name=[service_name];Enlist=False;Transaction Scope Local=True" /schemas:[schema_1],[schema_2]
In this example:
/Applications/CrossOver.app/Contents/SharedSupport/CrossOver/bin/wine
…is the command that initiates CrossOver.
--bottle 'dbForge_Studio_Oracle'
…is the parameter that specifies the name of the bottle that contains dbForge Studio for SQL Server.
--check --wait-children --start
…are the options that configure the launch of the application.
"C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com" /datacompare /source connection:"User Id=[yourusername];Password=yourpassword];Server=[X.X.X.X];Connect Mode=SysDba;Unicode=True;Pooling=False;Direct=True;Service Name=[service_name];Enlist=False;Transaction Scope Local=True" /target connection:"User Id=[yourusername];Password=[yourpassword];Server=[X.X.X.X];Connect Mode=SysDba;Unicode=True;Pooling=False;Direct=True;Service Name=[service_name];Enlist=False;Transaction Scope Local=True" /schemas:[schema_1],[schema_2]
…is the command to run the schema comparison with the specified options.
Worked example
Let us look at a worked example demonstrating how to compare the contents of two Oracle databases.
/Applications/CrossOver.app/Contents/SharedSupport/CrossOver/bin/wine --bottle 'dbForge_Studio_Oracle' --check --wait-children --start "C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com" /datacompare /source connection:"User Id=yourusername;Password=yourpassword;Server=10.10.102.139;Connect Mode=SysDba;Unicode=True;Pooling=False;Direct=True;Service Name=orcllast;Enlist=False;Transaction Scope Local=True" /target connection:"User Id=yourusername;Password=yourpassword;Server=10.10.102.139;Connect Mode=SysDba;Unicode=True;Pooling=False;Direct=True;Service Name=orcllast;Enlist=False;Transaction Scope Local=True" /schemas:DC_1,DC_2
The schema comparison process begins and finishes successfully.
Run a batch file
You can run not only individual commands but also generated batch files (*.bat/*.cmd files), which are to be created as usual Windows batch files.
Let’s look at an example of code for a batch file.
/Applications/CrossOver.app/Contents/SharedSupport/CrossOver/bin/wine --bottle "dbForge_Studio_Oracle" --check --wait-children --start "C:\users\crossover\My Documents\compare.bat"
In this example:
/Applications/CrossOver.app/Contents/SharedSupport/CrossOver/bin/wine
…is the command that initiates CrossOver.
--bottle 'dbForge_Studio_Oracle'
…is the parameter that specifies the name of the bottle that contains dbForge Studio for Oracle.
--check --wait-children --start
…are the options that configure the launch of the application.
"C:\users\crossover\My Documents\compare.bat"
…is the parameter that specifies the path to the batch file.
Note
You can automate the launch of dbForge Studio from the command line using any scheduler for macOS.
Want to Find out More?
Overview
All features
Request a demo
