Import SQL Azure Database to SQL 2008 R2

Question

Hi,

How can i import SQL Azure database into SQL 2008 R2 server.

 

Thanks,

Mrinal Jaiswal

 

---

Thanks, Mrinal Jaiswal

Answer 1

You can use the client side tools and the sample EXE available at CodePlex here:

http://sqldacexamples.codeplex.com/wikipage?title=Import%20Export%20Client%20Side%20Tools

 

Video tutorial is available here:

http://dacguy.wordpress.com/2011/09/09/importexport-services/

 

Or you can install SQL Server 2012 RC0 Management Studio and use the import/export wizards in SSMS.