MS SQL to MariaDB 1.1.8 (Dj-MsSql2Maria)

MS SQL to MariaDB 1.1.8 (Dj-MsSql2Maria) is a portable, standalone Windows desktop application (.NET 9 WPF). Drop one or more SQL Server .sql files — or a .bak backup file — into Dj-MsSql2Maria, point it at an output folder, enter your Target Database Name, click GO, and receive MariaDB-ready .sql output.

Every output file begins with CREATE DATABASE IF NOT EXISTS and USE statements for the database name you provide, so it can be imported directly into a fresh MariaDB instance without any manual editing.

When converting a BAK file you can independently choose whether to generate scripts for Tables and/or Data, and whether each should be written as a single consolidated file or as individual per-table .sql files (one script per table creation / one per table’s data).

No installer. No SQL Server. No internet connection. One .exe.

Feature	Detail
Input SQL File(s)	Select one or more MS SQL Server .sql files; all are converted and merged into one MariaDB output
BAK file	Best-effort SQL text extraction (no SQL Server needed)
BAK — Tables/Data toggle	Choose Tables only, Data only, or both
BAK — Consolidate CREATE TABLE	When checked: all CREATE TABLE scripts go into one consolidated .sql file. When unchecked (default): one .sql file per table.
BAK — Consolidate INSERT DATA	When checked: all INSERT DATA scripts go into one consolidated .sql file. When unchecked (default): one .sql file per table’s data.
Filename suffix	Optionally append a suffix (default _MariaDb) to the output filename
Real-time log	Scrollable black-background panel (yellow text) showing each file processed
Status panel	Scrollable black-background panel (green text) showing current operation state
Cancellable	STOP button halts processing immediately
Portable EXE	Single self-contained file, no runtime install required

Input Mode	Example Input	Example Output
Input SQL File(s)	Customers.sql or Customers.sql + Orders.sql	output_MariaDb.sql
MS SQL Server .BAK File	MyDatabase.bak	MyDatabase_MariaDb_tables.sql, MyDatabase_MariaDb_data.sql

This is a partial list — a representative sample of the most common conversions. The complete, grouped reference (REMOVE / ADDED / CONVERT) is in CONVERSION_REFERENCE.md.

Removed (sample)

These MS SQL tokens are deleted — nothing replaces them.

Removed from output
USE [DatabaseName]
SET ANSI_NULLS ON/OFF
SET QUOTED_IDENTIFIER ON/OFF
SET NOCOUNT ON/OFF
CLUSTERED / NONCLUSTERED
ON [PRIMARY] / TEXTIMAGE_ON [PRIMARY]
FILLFACTOR = n, PAD_INDEX = ON/OFF
ALLOW_ROW_LOCKS, ALLOW_PAGE_LOCKS

…and more. See the full list → CONVERSION_REFERENCE.md

Added (sample)

These items are inserted into the output where they did not exist before.

What is added	Why
Semicolons after CREATE TABLE blocks	MariaDB requires statement terminators
Backtick quoting on identifiers	MariaDB standard quoting style

…and more. See the full list → CONVERSION_REFERENCE.md

Converted (sample)

A representative sample of MS SQL → MariaDB replacements:

MS SQL	→	MariaDB
NVARCHAR(n)	→	VARCHAR(n)
NVARCHAR(MAX) / VARCHAR(MAX)	→	LONGTEXT
UNIQUEIDENTIFIER	→	CHAR(36)
BIT	→	TINYINT(1)
MONEY	→	DECIMAL(19,4)
DATETIME2	→	DATETIME(6)
IDENTITY(1,1)	→	AUTO_INCREMENT
[BracketedName]	→	`BacktickName`
dbo.TableName	→	TableName
GETDATE()	→	NOW()
GETUTCDATE()	→	UTC_TIMESTAMP()
DATEADD(part, n, date)	→	DATE_ADD(date, INTERVAL n part)
DATEPART(part, date)	→	EXTRACT(part FROM date)
LEN(expr)	→	CHAR_LENGTH(expr)
ISNULL(a, b)	→	IFNULL(a, b)
NEWID()	→	UUID()
N'string'	→	'string'
DEFAULT (getdate())	→	DEFAULT CURRENT_TIMESTAMP
IF EXISTS (…) DROP TABLE t	→	DROP TABLE IF EXISTS t
WITH (NOLOCK)	→	(removed entirely)

This is a partial list. For every conversion including all data types, all functions, all removed statements, and the “not converted / manual review” list, see the full reference: CONVERSION_REFERENCE.md

1. Download Dj-MsSql2Maria.exe from Releases.
2. Double-click to run — no installation needed.
3. In Dj-MsSql2Maria, choose your input type, browse for your file(s), pick an output folder, enter your Target Database Name, and click GO.

To build from source:

git clone https://github.com/DonaldJamesCompany/Dj-MsSql2Maria.git
cd Dj-MsSql2Maria
dotnet publish -c Release

Output: bin\Release\net9.0-windows\win-x64\publish\Dj-MsSql2Maria.exe

MS SQL to MariaDB (Dj-MsSql2Maria) — main window

• BAK extraction is best-effort (UTF-16/UTF-8 text scan). Compressed or encrypted BAK files yield little or no SQL. For guaranteed results, script the database with SSMS and use SQL file mode.
• SELECT TOP n — TOP n is removed during conversion. Add LIMIT n manually at the end of the query.
• DATEDIFF with non-day units is not fully converted — use TIMESTAMPDIFF manually.
• Complex T-SQL (MERGE, PIVOT, TRY/CATCH, cursors, etc.) is not converted and requires manual rewriting.

Full list → CONVERSION_REFERENCE.md — NOT CONVERTED section

Document	Audience	Description
USER_MANUAL.md	End users	Step-by-step guide to using the application
CONVERSION_REFERENCE.md	Developers	Complete reference of every REMOVE / ADDED / CONVERT transformation

Pull requests are welcome. Please open an issue first to discuss significant changes.

1. Fork the repository
2. Create a feature branch: git checkout -b feature/my-conversion
3. Commit your changes
4. Push and open a Pull Request

This project is licensed under the MIT License. Copyright © Donald James Company. Source code is available on GitHub.