Toad World® Forums

Automated conversion from T-SQL To Ansi SQL?


#1

Is there an automated tool to convert from Microsoft SQL Server T-SQL to a different ANSI format (Neteeza, Teradata, Greenplum, Hana)? If so, what is the product name and is there a training video?

We have thousands of items so doing it manually is not an option (except for testing).


#2

If you are just looking to rewrite your joins in ANSI SQL syntax, Dell’s SQL Optimizer for SQL Server can rewrite SQL statements automatically using ANSI SQL.