What is yuniql?
YUNIQL (yuu-nee-kel) is a free and open source schema versioning and migration tool made with .NET Core. Run migrations with plain SQL, arrange versions in ordinary folders and seed your data from CSV. Released as stand-alone CLI (no CLR needed!), Azure Pipelines, Docker or ASP.NET Core code.
TL;DR; Why yuniql?
It's raw SQL. Yuniql follows database-first approach in versioning your database. Versions are normal directories or folders. Scripts are series of plain old .sql files. No special tool or language required.
It's .NET Core Native. Released as a self-contained .NET Core 3.0 application. Yuniql doesn't require any dependencies or CLR installed on the developer machine or CI/CD server. For windows, yuniql.exe is ready-for-use on day 1.
Bulk Import CSV. Load up your master data and lookup tables from CSV files. A powerful feature when provisioning fresh developer databases or when taking large block of master data as part of a new version.
DevOps Friendly. Azure Pipeline Tasks available in the Market Place. Use Yuniql task acquires a specific version of the Yuniql. Run Yuniql task runs database migrations with Yuniql CLI using version acquired earlier.
Cloud Ready. Platform tested for Azure SQL Database, Amazon RDS and Google Cloud SQL. Plugins for Snowflake, Aurora and Azure Synapse Analytics are lined up for development.
Docker Support. Each project is prepared for containerized execution using Yuniql base images. A dockerized database project is cheap way to run migration on any CI/CD platform.
Cross-platform. Works with Windows and major Linux distros.
Open Source. Released under Apache License version 2.0. Absolutely free for personal or commercial use.
- 382 Stars
- 59 Forks
- 95 Open Issues