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)
Import a BACPAC File to Create a New User Database
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
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.