Contains source code for database project and documentation on how to migrate from framework based project to SDK based project. This SQL Database project can be developed, built and published from windows, linux, osx or Docker container.

dotnet new install Microsoft.Build.Sql.Templates

dotnet new sqlproj -n Database.DacFx

If you are planning to keep both projects for any reason, copy database objects (.sql) scripts from existing project to new project

You can create new objects as plain .sql scripts and put it anywhere in the new project.

For example, here's Tables/User.sql script to create User table.

CREATE TABLE [dbo].[User](
    [UserId] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [Name] [varchar](50) NOT NULL
);

VS Code tasks are configured to build database, publish database and run unit tests.

dotnet build

Install SqlPackage as dotnet tool dotnet tool install -g microsoft.sqlpackage

sqlpackage /Action:Publish /SourceFile:"bin/Debug/Database.DacFx.dacpac" /TargetServerName:"(localdb)\MSSQLLocalDB" /TargetDatabaseName:Database.DacFx

Another way to deploy changes to database is to copy contents of script from bin/Debuig/Database.DacFx_Create.sql and run it using SSMS or sqlcmd tool.

docker build -t todo-database .

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=SuperSecretPassword#1" \
   -p 1433:1433 --name sql1 --hostname sql1 \
   todo-database

• Using SSMS

  • Server: localhost,1433
  • Authentication method: SQL Server Authentication
  • User: sa
  • Password: SuperSecretPassword#1

• Connection String

  Server=localhost,1433;Database=Database.DacFx;User=sa;Password=SuperSecretPassword#1;TrustServerCertificate=true

docker rm -f sql1

• DacFx

• Quick start - MS SQL Docker

• sqlcmd

• SSMS