Blog Stats
  • Posts - 132
  • Articles - 0
  • Comments - 28
  • Trackbacks - 0

 

Thursday, August 04, 2011

Migrate Database to SQL Azure


 

This is very cool

Just found this fab, tool to generate all the insert statements you need from a SQL database.

If you have SQL Server 2008 R2 Installed -

Run

"C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe"

image

This lets you select individual tables, views, stored procedures and script out both data and schema structures.

Perfect for populating SQL Azure, when migrating from on-Premise databases.

 

 

Copyright © Richard Jones