Geeks With Blogs
Mobile Line Of Business Richard Jones (MVP)

 

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.

Posted on Thursday, August 4, 2011 4:31 AM | Back to top


Comments on this post: Migrate Database to SQL Azure

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Richard Jones | Powered by: GeeksWithBlogs.net | Join free