dbdiagram.io diagram generator for MS SQL

Draw a database diagram of your MS SQL database in dbdiagram.io.

The repository

DbDiagramIo.MsSql: Library to export MS SQL database schema into a script that dbdiagram.io understands.
Example.DotNetCore: .NET Core example application that actually creates the dbdiagram.io script by using the library.
Example.DotNet461: .NET 4.6.1 example application.

Try it

cd src and open the .sln file with Visual Studio
set the connection string in Example.DotNetCore\Program.cs to point to your database
build the solution using Visual Studio
run the application using dotnet Example.DotNetCore.dll
copy&paste the application's output to https://dbdiagram.io/d
see your database's diagram

Create your own application

Use the DbDiagramIo.MsSql library in your code and create a better MS SQL => dbdiagram.io export tool.

Add the nuget package

dotnet add package DbDiagramIo.MsSql

Import the namespace

using DbDbiagramIo.MsSql;

Generate dbdiagram.io script

(TableDto[] tables, ForeignKeyDto[] foreignKeys) = MsSqlSchemaReader.ReadTablesAndForeignKeysFromDb( "<YOUR-DB'S-CONNECTIONSTRING>" );

foreach (TableDto table in tables)
{
    Console.WriteLine( table.ToDbDbiagramCode() );
}

foreach (ForeignKeyDto fk in foreignKeys)
{
    Console.WriteLine( fk.ToDbDiagramDto() );
}

Why

SQL Server Management Studio 18 no longer supports diagrams. dbdiagram.io is a free tool to draw DB diagrams, however currently it does not have an "import from ms sql" feature. This project provided a quick & dirty way for me to generate DB diagrams for my MS SQL databases.

david-zoltan/dbdiagramio-mssql