Sql Azure Database Backup and Restore using C#

Question

I am working on Sql Azure Database Backup and restore functionality.

Question: - Can we Backup more than one database into a single bacpac file using "Microsoft.SqlServer.Dac" - Can we read the bacpac file in our C# so that we can know which database backup is this. - Can we restore more than one database at a time. - Can we override the existing database using Microsoft.SqlServer.Dac.

I am able to take one database backup, restore (not override) using "Microsoft.SqlServer.Dac".

I searched in google find the above questions answer but failed to get any solutions.

Please suggest

Is there any way to take backup/restore and override the bacpac file in sql Azure using C#.

With C# alone u'll not be happy in Azure. All operations in the new Azure Resource Manager can be called by PowerShell and Azure CmdLets. But you can execute the CmdLets with C#. However I do not know any command which provides this functionality. And IIRC a bacpac file does not provide the opportunity to backup multiple databases. — Benjamin Abt
– Benjamin Abt, Commented Jan 19, 2016 at 9:39
@Ben can we take backup/restore multiple database using PowerShell or Azure CmdLets — bhagirathi
– bhagirathi, Commented Jan 19, 2016 at 10:22

Joseph Idziorek · Accepted Answer · 2016-01-23 15:15:34Z

1

.bacpac files for Azure SQL Database are scoped to individual databases and their currently is no way backup two databases in a single .bacpac file.

answered Jan 23, 2016 at 15:15

Joseph Idziorek

5,0997 gold badges26 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql Azure Database Backup and Restore using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related