Add commands to import from existing database or bacpac

[egil]

Related to an existing integration?

Yes

Existing integration

Hosting.SqlDatabaseProjects

Overview

Add commands "Import database" and "Import BacPac" to a SQL Server Database resource. While not related to DacPacs, it is very similar, and users are likely to need both features. The DacServices library is also used for this.

I have a "works on my machine" implementation shared here that could be a starting point for this feature: https://gist.github.com/egil/f3a9d42f58862913d95dbc0b6bba494e

Usage example

var builder = DistributedApplication.CreateBuilder(args);

var sqlPassword = builder.AddParameter("sql-password", secret: true);
var sqlserver = builder
    .AddSqlServer("sqlserver", password: sqlPassword)
    .WithDataVolume()
    .WithLifetime(ContainerLifetime.Persistent);

var importSourceConnectionString = "Server=[REPLACE].database.windows.net;Authentication=Active Directory Interactive;Database=[REPLACE];Encrypt=True;"
var db = sqlserver
    .AddDatabase("[REPLACE]")
    .WithDatabaseImportCommand(importSourceConnectionString);

var conStrResource = builder.AddConnectionString("my-source-database");
var db2 = sqlserver
    .AddDatabase("[REPLACE]")
    .WithDatabaseImportCommand(conStrResource);

var bacPacFilename = @"c:\backups\my-database.bac";
var db3 = sqlserver
    .AddDatabase("[REPLACE]")
    .WithBacPacImportCommand(bacPacFilename);

This is how one of the commands looks in the Aspire UI based on the sample in my GIST:

Breaking change?

No

Alternatives

It could be released as a standalone package instead of including it in SqlDatabaseProjects.

Additional context

I published my GIST and got positive feedback on bsky: https://bsky.app/profile/did:plc:ng6rx44bjxrvoowr4ny6jpl3/post/3ldk2zrundc2g

Help us help you

Yes, but only if others can assist