SQL converter
Rewrite quoting, escaping, row limits and function names between 16 dialects, with a list of what it refused to guess at.
IBM Db2 query
SQL Server (T-SQL) query
What it changed
VARCHARNVARCHAR1 place
What you still need to do
Anything left in this list was recognised and left as it was on purpose. A function renamed to one that takes its arguments in a different order produces SQL that runs and returns the wrong rows, which is worse than SQL that fails.
Converting IBM Db2 to SQL Server (T-SQL): Key Syntax Differences
Translating SQL queries between IBM Db2 and SQL Server (T-SQL) involves subtle dialect differences that standard text find-and-replace often misses. Everything below is processed entirely in your browser using SQLParity.
Identifier Quoting
IBM Db2: "name"
SQL Server (T-SQL): [name]
String Literal Escaping
IBM Db2: Quotes are doubled (''), backslash is literal.
SQL Server (T-SQL): Quotes are doubled (''), backslash is literal.
Null-Safe Equality
SQL Server (T-SQL): (colA <> colB OR (colA IS NULL AND colB IS NOT NULL) OR (colA IS NOT NULL AND colB IS NULL))
Why In-Browser SQL Conversion Matters
Database migrations frequently involve proprietary business logic, sensitive table schemas, and production column names. When converting SQL between IBM Db2 and SQL Server (T-SQL), SQLParity executes all parsing, tokenization, and code rewriting locally in your browser. Zero queries or schemas are transmitted to remote servers.