Add BACPAC to SQL Compare (and SQL Data Compare)
At the moment you can compare Database, Backup, Snapshot and Source Control.
Please add a BACPAC file as well.
A BACPAC is an artifact that encapsulates the database schema as well as the data stored in the database. The BACPAC is a Windows file with a .bacpac extension. Similar to the DACPAC, the BACPAC file format is open – the schema contents of the BACPAC are identical to that of the DACPAC. The data is stored in JSON format.
How to: Import and Export a Database (Windows Azure SQL Database)
http://msdn.microsoft.com/en-us/library/windowsazure/hh335292.aspx
Import a BACPAC File to Create a New User Database
http://msdn.microsoft.com/en-us/library/hh710052.aspx
Simon de Kraa
shared this idea
-
Brent Templeton
commented
I am attempting to do this exact thing, compare a bacpac -- this comment is very old, is there any traction on doing this?
-
Simon de Kraa
commented
@David
At the moment you can Export a SQL Azure database from the Azure Management Portal (and using REST API) as a BACPAC file.
In SSMS 2012 you can also Import a database from a BACPAC file. -
Thanks for the request. This is something we're keen on doing, especially as the popularity of the dacpac/bacpac format increases. Please continue voting for this if this is something you're now using. I'd be interested to learn more about what you're using these 'snapshots' for.
-
Andrew Thompson
commented
I totally support this BACPAC feature request.
BACPACs are becoming an ever more important part of Microsoft Azure's database technologies.
