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"