Home / SQL checker

SQL migration checker

Paste SQL Server, Oracle or Teradata SQL and see which functions need a change in Snowflake, Databricks or BigQuery. Safe renames are applied automatically. Your SQL never leaves the browser.

FromTo

SQL

Matches function names only and does not parse the full grammar. Functions without a page here are listed separately; that does not mean they are compatible.

The checker needs JavaScript. You can also browse the migration checklists from the home page.

How it decides

Each function call is matched against the reference pages for the selected source. Calls whose target spelling differs, or that need a rewrite, are listed with the target syntax.
A call is renamed automatically only when the target function takes the same arguments with the same meaning, for example ISNULL to IFNULL. Everything else is left for you, because argument order, NULL handling or return types differ.
Calls that keep working as written are not listed, but their pages may still describe behavior differences.

Covered so far: CHARINDEX, CONVERT, CROSS APPLY, DATEADD, DATEDIFF, DATEFROMPARTS, DATEPART, EOMONTH, FORMAT, GETDATE, IIF, ISNULL, LEN, NEWID, PATINDEX, STRING_AGG, STRING_SPLIT, STUFF, TOP, TRY_CAST, ADD_MONTHS, CONNECT BY, DECODE, DUAL, INSTR, LISTAGG, MONTHS_BETWEEN, NVL, NVL2, REGEXP_SUBSTR, ROWNUM, SYSDATE, TO_CHAR, TO_DATE, TRUNC (date), NULLIFZERO, OREPLACE, QUALIFY, SAMPLE, ZEROIFNULL, APPROXIMATE COUNT(DISTINCT), CONVERT_TIMEZONE, DATEDIFF, GETDATE, JSON_EXTRACT_PATH_TEXT, LISTAGG, MEDIAN, SPLIT_PART.