SQL Centre of Excellence

SWEET! you can now access windows Azure Storage Directly from SQL Server Management Studio. This means you can now simply right click on a backup taken in SQL Azure and select “Import Data-Tier Application” to import the “bacpac” file onto your on-premise SQL Server. 2-3 clicks of the mouse and cloud zapped to local database.

image

You can also now right click on any on-premise database and select “Export Data-Tier Application” to create a bacpac and upload it direct into SQL Azure. Check out the new export screen shot below.

image

I’m still a big fan of the Import Wizard on codeplex (http://sqlazuremw.codeplex.com/) as it automatically fixes up minor issues like missing clustered indexes. However, the bacpac way is  going to be a lot more efficient for larger data sets as it is compressed. You can even rename it to a “zip” file to poke around.

Holy crap there is also a “Deploy” to SQL Azure option in SQL 2012 RTM, where you can pick also create the database and provisioning is all automated. Nice..

image

So its pretty good for a v1.0, but what is it missing?

Well life would be just complete if you could right click on a SQL Azure database and the “Export” Task did an export from SQL Azure rather than dragging everything locally and doing and creating a bacpac from your machine. If anyone else would like this please vote on connect item I just added.

https://connect.microsoft.com/SQLServer/feedback/details/730735/improve-export-of-a-sql-azure-database-from-ssms

blog comments powered by Disqus

Page List

Page List