15 incompatibilities detected automatically

Your database migration will break on the first DELETE.Find the risk before you run the script.

Paste your T-SQL (SQL Server) and get an instant syntax audit for PostgreSQL. Spot invalid JOINs, incompatible functions, and dangerous queries before running in production.

🔒 100% Secure — code never stored</> Analysis via AST Parser + Semantic Regex⚡ Results in < 1 second

</> Scan Java / C# Repository ⚡ Audit .sql Scripts How it works →

SQLShifter Advantage

Your team will migrate code without opening file by file.

Upload your repositories in Java, C# (.NET), JavaScript, Python, or PHP and our tool extracts, analyzes, and pinpoints exactly which classes in your system will break after the database migration.

Finds queries inside the repository automatically
Report with file, line, and extracted SQL — ready for your team

Scan source code for free

PedidoService.java — line 42HIGH RISK

@Query(value = """
    SELECT TOP 100 p.* FROM dbo.Pedidos p
    INNER JOIN dbo.Clientes c ON c.Id = p.ClienteId
    WHERE p.Data > DATEADD(month, -6, GETDATE())
    """, nativeQuery = true)
List<Pedido> findRecentes();

⚠ We found a risky query

dbo. · TOP · DATEADD · DELETE/JOIN pattern — incompatible with PostgreSQL

Java

@Query, @NamedNativeQuery, JDBC strings

C# .NET

Dapper, EF FromSqlRaw, @"verbatim"

JS / TS

Template literals, Sequelize, pg

Python

Django .raw(), cursor.execute

PHP

PDO, sqlsrv, $sql variables

Migration Impact Panel

Paste your T-SQL on the left — risk appears on the right instantly.

migration_script.sql — SQL Server (T-SQL)

123456789101112131415161718

DELETE t
FROM dbo.Funcionarios t
INNER JOIN dbo.Pagamentos p
    ON t.FuncionarioId = p.FuncId
WHERE p.Status = 'CANCELADO';

-- Coluna calculada — quebra no PostgreSQL
CREATE TABLE dbo.Funcionarios (
    Id      INT IDENTITY(1,1) PRIMARY KEY,
    Nome    VARCHAR(100),
    Salario DECIMAL(10,2),
    -- ERRO: AS (expr) → GENERATED ALWAYS AS
    Liquido AS (Salario - ISNULL(Desconto, 0)),
    -- ERRO: DATEDIFF não existe
);

SELECT DATEDIFF(day, DataAdmissao, GETDATE()) AS Dias
FROM dbo.Funcionarios WHERE ativo = 1;

⚡ Run Free Audit

Risk Level

HIGH

Guaranteed failure in production

Incompatibilities

4 found

in 2 statements

Critical Issues Detected

❌
Lines 1–5: DELETE with INNER JOIN
PostgreSQL rejects JOIN directly in DELETE. Requires a USING clause.
❌
Line 13: Computed column AS (expr)
Requires GENERATED ALWAYS AS (expr) STORED in PostgreSQL.
❌
Line 1: dbo. prefix (schema)
dbo. does not exist by default in PostgreSQL — use public. or remove it.
⚠️
Line 18: DATEDIFF does not exist in PostgreSQL
Use (d2::date - d1::date) or EXTRACT depending on the unit.

PostgreSQL — Translated Code

DELETE FROM funcionarios t
USING pagamentos p
WHERE t.funcionario_id = p.func_id
  AND p.status = 'CANCELADO';

CREATE TABLE funcionarios (
    id SERIAL PRIMARY KEY,
    liquido NUMERIC GENERATED ALWAYS AS
        (salario - COALESCE(desconto, 0)) STORED
);

🔒

Converted and optimized code ready.

Upgrade to unlock the corrected script.

Unlock Corrected Code

The Silent Killers

Errors that pass review and explode in production

Each of these patterns is accepted in SQL Server and causes immediate failure in PostgreSQL.

🗑️

DELETE with JOIN

T-SQL accepts DELETE t FROM Table t JOIN. PostgreSQL rejects direct JOIN — requires USING.

✗ DELETE t FROM t JOIN p ON...

✓ DELETE FROM t USING p WHERE...

📊

PIVOT → CASE WHEN

PostgreSQL has no native PIVOT. Matrix reports require SUM(CASE WHEN...) + GROUP BY.

✗ PIVOT(SUM(val) FOR mes IN...)

✓ SUM(CASE WHEN mes='Q1'...)

📅

DATEDIFF / GETDATE()

DATEDIFF and GETDATE() do not exist in PostgreSQL. NOW() does not exist in SQL Server.

✗ DATEDIFF(day, d1, GETDATE())

✓ (NOW()::date - d1::date)

⚠️

TRY/CATCH + @@ROWCOUNT

BEGIN TRY and @@ROWCOUNT do not exist in PL/pgSQL — code compiles but silently ignores errors.

✗ BEGIN TRY ... IF @@ROWCOUNT = 0

✓ EXCEPTION WHEN ... IF NOT FOUND

How it works

3 steps from risk to certainty.

📁

Step 1

Upload .sql or repository

Upload SQL scripts or source files (.java, .cs, .py…) — we extract hidden queries. Nothing is stored.

🔍

Step 2

Get the Impact Report

Visual diagnosis with compatibility %, mapped critical points, and expert notes.

⬇️

Step 3 (Pro)

Export the converted project

Download the full PostgreSQL script — semantics preserved, indexes kept, procedures restructured.

Pay only for what you use

Per-file credits — one-time payment, no subscription.

Free

3 files · up to 1000 lines per file

✓3 lifetime files
✓Up to 1,000 lines per file
✓Full impact report
✓.sql scripts and Java/C#/JS/Python/PHP code
✕Converted ZIP (paid credits)
✕Script export

Start for free

Starter

$9.00

5 files

up to 2000 lines per file

One-time payment — credits never expire

Buy credits

Pro

$29.00

15 files

up to 3000 lines per file

One-time payment — credits never expire

Buy credits

Team

$79.00

40 files

up to 5000 lines per file

One-time payment — credits never expire

Buy credits

Business

$199.00

100 files

up to 10000 lines per file

One-time payment — credits never expire

Buy credits