Differences

This shows you the differences between two versions of the page.

cmd [April 07, 2016 3:50 am]
sqlines
cmd [April 29, 2021 6:38 am] (current)
sqlines
Line 1: Line 1:
-====== SQLines Tool - Command Line Reference ======+====== SQLines SQL Converter - Command Line Reference ======
-SQLines tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers between databases.+SQLines SQL Converter tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers between databases.
SQLines converts SQL statements located in one or more **files**, not from a database. SQLines converts SQL statements located in one or more **files**, not from a database.
Line 24: Line 24:
| **-omapf** | Database object name mapping file | No mapping | | **-omapf** | Database object name mapping file | No mapping |
| **-meta** | Column meta data file | No meta data | | **-meta** | Column meta data file | No meta data |
 +| **-a** | Create assessment report | |
===== -s and -t - Source and Target Database Types ===== ===== -s and -t - Source and Target Database Types =====
Line 43: Line 44:
| 10 | //teradata// | Teradata | | 10 | //teradata// | Teradata |
| 11 | //netezza// | Netezza | | 11 | //netezza// | Netezza |
 +| 12 | //mariadb// | MariaDB |
 +| 13 | //mariadb_ora// | MariaDB Oracle Compatibility mode |
 +| 14 | //hive// | Apache Hive |
 +| 15 | //redshift// | Amazon Redshift |
 +| 16 | //snowflake// | Snowflake |
 +| 17 | //spark// | Spark |
 +| 18 | //trino// | Trino, Presto |
For example, specify the following command line to convert //script.sql// file from MySQL to Oracle: For example, specify the following command line to convert //script.sql// file from MySQL to Oracle: