dbatools/sqlinstance2 repository overview

docker pull dbatools/sqlinstance
docker pull dbatools/sqlinstance2

# Create network for nodes to talk to each other
docker network create localnet
# Expose engine and endpoint then setup a shared path for migrations
# NOTE: The syntax below is for mac. For Windows, it's an extra step.
docker run -p 1433:1433 -p 5022:5022 --volume /tmp:/sharedpath --network localnet --hostname dockersql1 --name dockersql1 -d dbatools/sqlinstance
# Expose second engine and endpoint on different port
docker run -p 14333:1433 -p 5023:5023 --volume /tmp:/sharedpath  --network localnet --hostname dockersql2 --name dockersql2 -d dbatools/sqlinstance2

# let it finish starting
Start-Sleep 15

$params = @{
    Primary = "localhost"
    PrimarySqlCredential = $cred
    Secondary = "localhost:14333"
    SecondarySqlCredential = $cred
    Name = "test-ag"
    Database = "pubs"
    ClusterType = "None"
    SeedingMode = "Automatic"
    FailoverMode = "Manual"
    Confirm = $false
 }
 
 New-DbaAvailabilityGroup @params

Start-DbaMigration -Source localhost:1433 -Destination localhost:14333 -SourceSqlCredential $cred -DestinationSqlCredential $cred -BackupRestore -SharedPath /sharedpath -Exclude LinkedServers, Credentials, CentralManagementServer, BackupDevices