Mobile Line Of Business

Richard Jones (MVP)

  Home  |   Contact  |   Syndication    |   Login
  202 Posts | 0 Stories | 36 Comments | 0 Trackbacks

News

Welcome to the Mobile Line Of Business Blog

Tag Cloud


Archives

About

 

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