SQLParity

SQL converter

Rewrite quoting, escaping, row limits and function names between 16 dialects, with a list of what it refused to guess at.

1

SQL Server (T-SQL) query

2

PostgreSQL query

What it changed

  • TOP 10LIMIT 101 place
  • [name]"name"8 places
  • ISNULL()COALESCE()1 place
  • LEN(x)LENGTH(RTRIM(x))1 place
  • current timestampCURRENT_TIMESTAMP1 place

What you still need to do

Nothing in this query is the kind of thing that translates wrongly. Still run it once before you trust it.

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.