Skip to content Skip to sidebar Skip to footer

Sql Azure Bacpac Extraction

How to programmatically (C#) extract a BACPAC file from a SQL Azure Database? I was thinking in terms of creating a azure job to extract this bacpack file and save it to my storage

Solution 1:

Add microsoft.sqlserver.dac.dll

SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();
csb.DataSource = "servername";
csb.Password = "whatever";
csb.UserID = "whatever";

DacServices ds = new DacServices(csb.ConnectionString);
ds.ExportBacpac(@"C:\backup\backup.bacpac");

Post a Comment for "Sql Azure Bacpac Extraction"