Access to T-SQL Script Builder — Migration Script Generator

Q: Does the tool handle relationships and foreign keys?

Yes. The tool reads Access relationships from the MSysRelationships system table when available. Tables are topologically sorted so parent tables are created and populated before child tables. Foreign key constraints are generated in a separate script.

Drop a Microsoft Access database file (.mdb or .accdb) and get a complete, ordered set of T-SQL migration scripts for SQL Server. Schema creation, data inserts, relationships, and a validation report — all generated locally in your browser. Supports every Jet and ACE version.

Access → SQL Server

Drop an .mdb or .accdb file to generate a complete T-SQL migration script

Jet 3 (Access 97) Jet 4 (Access 2000–2003) ACE 12 (Access 2007) ACE 14 (Access 2010) ACE 15 (Access 2013) ACE 16 (Access 2016–2021)

🗃️

Drop your Access database here

or Browse Files · .mdb or .accdb

Waiting for file…

Format —

Tables —

Total Rows —

Relationships —

⚙ Migration Settings

Database Name

Schema

Batch Size (rows per INSERT)

Default NVARCHAR Length

Include CREATE DATABASE / USE Include IF EXISTS / DROP before CREATE Wrap data inserts in a transaction SET IDENTITY_INSERT ON for AutoNumber columns Include relationship / foreign key constraints Add GO batch separators

📋 Schema Overview

🔗 Detected Relationships

🔀 Type Mapping Overrides

What Does This Tool Do?

The Access to T-SQL Script Builder reads a Microsoft Access database file (.mdb or .accdb) entirely in your browser using mdb-reader, a pure JavaScript parser that supports all Jet and ACE database engine versions. It inspects the schema — tables, columns, data types, relationships, and indexes — and generates a set of numbered T-SQL scripts that recreate the entire database in SQL Server.

The scripts are ordered for dependency safety: database creation first, then tables in topological order (parents before children), data inserts with configurable batch sizes, foreign key constraints derived from Access relationships, and finally a validation report that checks row counts match the source.

Supported Access Versions

Engine	Version	Extension	Access Version
Jet 3	3.x	.mdb	Access 97
Jet 4	4.x	.mdb	Access 2000, 2002 (XP), 2003
ACE 12	12.x	.accdb	Access 2007
ACE 14	14.x	.accdb	Access 2010
ACE 15	15.x	.accdb	Access 2013
ACE 16	16.x	.accdb	Access 2016, 2019, 2021, Microsoft 365

Generated Script Breakdown

Script	Contents	Purpose
01_Create_Database.sql	CREATE DATABASE, USE, optional DROP	Set up the target database
02_Schema.sql	CREATE TABLE with mapped types, PKs, indexes	Recreate all table structures
03_Data_*.sql	Batched INSERT statements per table	Migrate all row data
04_Foreign_Keys.sql	ALTER TABLE ADD CONSTRAINT for relationships	Restore referential integrity
05_Validation.sql	Row count checks per table	Verify migration completeness

Type Mapping Reference

Access Type	Default SQL Server Type	Notes
AutoNumber (Long Integer)	INT IDENTITY(1,1)	Auto-incrementing primary key
Short Text / Text	NVARCHAR(n)	Unicode; length from field size or default
Long Text / Memo	NVARCHAR(MAX)	Unlimited-length text
Number (Byte)	TINYINT	0 to 255
Number (Integer)	SMALLINT	–32,768 to 32,767
Number (Long Integer)	INT	Standard 32-bit integer
Number (Single)	REAL	Single-precision float
Number (Double)	FLOAT	Double-precision float
Number (Decimal)	DECIMAL(18,6)	Override precision in mapping panel
Currency	MONEY	Fixed-point to 4 decimal places
Date/Time	DATETIME2	Higher precision than legacy DATETIME
Yes/No	BIT	Boolean 0/1
OLE Object	VARBINARY(MAX)	Binary large objects
Hyperlink	NVARCHAR(MAX)	Link text stored as delimited string
GUID / Replication ID	UNIQUEIDENTIFIER	16-byte GUID

Frequently Asked Questions

Does my Access database get uploaded to a server?▼

No. The tool uses mdb-reader (a pure JavaScript MDB/ACCDB parser) to read your database entirely in your browser. Your data never leaves your device.

What file formats and Access versions are supported?▼

The tool supports .mdb files (Jet 3 from Access 97, Jet 4 from Access 2000–2003) and .accdb files (ACE 12–16 from Access 2007 through Microsoft 365). All standard Microsoft Access database formats are covered.

Can I customize how Access types map to SQL Server types?▼

Yes. After loading a file, a Type Mapping panel shows every detected Access column type with a dropdown to change the target SQL Server type. Overrides are applied when you generate the script.

Does the tool handle Access relationships?▼

Yes. The tool reads Access relationships from the system tables. Tables are topologically sorted so parent tables are created and populated before child tables. Foreign key constraints are generated in a separate script so you can apply them after all data is loaded.

How large a database can this handle?▼

The tool runs in your browser, so practical limits depend on available RAM. Access databases up to a few hundred MB work well on modern machines. The Access format itself has a 2 GB limit.

Can I run the scripts against Azure SQL Database?▼

Yes. Uncheck "Include CREATE DATABASE / USE" to skip database-level commands. The schema and data scripts use standard T-SQL that works on Azure SQL, SQL Server 2016+, and SQL Server on Linux.

Does the tool handle Access queries, forms, or reports?▼

This tool focuses on table data migration — the schema and row data that can be faithfully reproduced in SQL Server. Access queries, forms, reports, macros, and VBA code are application-level objects that cannot be directly translated to T-SQL.