You can use sudo if you are installing to the system site packages. snowconvert-export-oracle can be installed using the --user option, which does not require sudo for example:$ pip3 install snowconvert-export-oracle --upgrade --user
After installation you can test if the tool is properly installed by running
$ sc-oracle-export -h
If the tool is properly installed you will see an output like:
For example for a local installation you will run it like this:
$ ./sc-oracle-export -S orcl -HO localhost:1521 -U system -P manager
The tool will ask to install the SQLCL and the JDK. If you do not have sqlplus or sqlcl installed it is better to follow this step if no type no. You will then be asked for: INCLUDE_OPERATOR,INCLUDE_CONDITION, EXCLUDE_OPERATOR, EXCLUDE_CONDITION These values are used to customize which schemas are included or not.
An example of the output of the tool will be:
This script will install the Oracle SQLCL tool and JDK to enable connection to your database
Install tools to connect to Oracle (yes/no/cancel)
Creating the scripts to export object DDLs
Updating DDL export scripts....
1. Enter value for the 'INCLUDE_OPERATOR'(e.g. LIKE, IN, =, NOT IN, NOT LIKE): LIKE
2. Enter value for the 'INCLUDE_CONDITION':(OWNER1, ONWER2)
3. Enter value for the 'EXCLUDE_OPERATOR'(e.g. LIKE, IN): IN
4. Enter value for the 'EXCLUDE_CONDITION':('SCHEMA3', 'SCHEMA4')
If nothing was entered, we will be using these default values: 1=LIKE 2=(OWNER1, ONWER2)3=IN 4=('SCHEMA3', 'SCHEMA4')
NOTE: Run this script with your oracle tools. For example sqlplus USER/[email protected]/SERVICE @./scripts/create_ddls.sql
Cleaning up empty output files
You can now run the script ./scripts/create_ddls.sql to export your Oracle DDLs
The tool will ask before writing the scripts.
After running the tool a new folder called scripts gets created with the customized create_ddls.sqlYou can open it on an editor and customize it even further.
After that just go to the scripts folder and run it.
When the script is done, the output folder will contain all the DDLs for the migration.
You can then compress this folder to use with SnowConvert