What it does
SQLines SQL Converter translates database DDL, queries, DML, views, stored procedures, packages, functions, and triggers between supported SQL dialects.
Translate SQL files or statements after selecting source and target dialects. The vendor's CLI reference supports single files, wildcard batches and standard input/output; a simple file conversion writes a separately named output script. Target-version and identifier/schema mapping options control the generated SQL, and assessment reports describe encountered constructs. SQL Converter handles SQL language and program objects; the separate SQLines Data tool handles live data/schema movement. The linked repository is Apache-2.0 open source, while vendor download/support/licence terms must be matched to the selected build.
Strengths
- Covers stored program objects as well as schema and query statements.
Best for
- Database migrations that require SQL dialect translation