Why A1 Data Migrator exists
Teams that decide to move off SQL Server usually face the same wall: dozens of tools that translate schema half-way, lose check constraints, mishandle nvarchar, give up on triggers and stored procedures, and then leave you to chase foreign keys by hand. The job that should take an afternoon turns into a three-week consulting engagement.
We hit that wall ourselves while moving a 5 GB production database off MSSQL. A weekend later we had a wizard that did the whole thing in four phases, captured every trigger and procedure into a metadata table for a developer to review, and re-applied foreign keys in the right order so nothing failed mid-migration. We packaged it, gave it a license, and that became A1 Data Migrator.
How we think about the product
One source, four targets
Point it at SQL Server and migrate to the database you actually want: PostgreSQL, MySQL, SQLite, or MongoDB. The same wizard and the same four phases — you simply pick the destination.
Four phases, never half-done
Phase 1 schema. Phase 2 data. Phase 3 indexes & foreign keys. Phase 4 check constraints & finalise. Every phase is restartable. If something fails on row 3 million, you fix it and resume - you don't start over.
Honest about what we cannot translate
T-SQL triggers, stored procedures, views, and functions are exported into a _metadata table on the target with full source text. We do not silently rewrite them - we hand them to your developer with a list. You see what you're getting.
Local, single binary
One .exe, self-contained, no .NET install required, no cloud, no telemetry. Your data never leaves the box you run it on.
Arabic-native, English-friendly
The wizard is bilingual end-to-end. Arabic data is preserved as text with UTF-8 encoding on PostgreSQL, with collation aware of MENA locales.
Roadmap highlights
2026 Q2
v1.0 release - SQL Server -> PostgreSQL / MySQL / SQLite / MongoDB, 4-phase wizard, metadata export
2026 Q3
Reverse direction: PostgreSQL -> SQL Server (for clients undoing a migration)
2026 Q4
Stored-procedure auto-translator (CTE-friendly subset of T-SQL -> PL/pgSQL)
2027 Q1
MySQL and Oracle source connectors
What we won't do
We will not upload your data anywhere. We will not lock you into a proprietary format - the metadata table is plain PostgreSQL rows you can drop after you've ported the procedures. We will not surprise-renew. The trial is 30 days, no credit card, and the license is honest about being machine-bound.