Script to export tables,store procedures and data in SQL Server Management Studio Expres

how i can do a script to export tables,store procedures and data in SQL Server Management Studio Expres

I just arrive to do a script for tables and stores procedures

help please

hi,

this feature is not supported in SQL Server Management Studio (and SSMSExpress too)... you can only script out the DDL to re-create the initial objects but not to populate them..

if you like, you can have a look at 2 free prjs of mine at http://www.asql.biz/en/Download2005.aspx..

amScript is to generate DDL scripts, where amInsert is to generate INSERT INTO scripts to populate existing tables...

regards

|||

Our web hosting team is working on a tool that will do much of this as well. You can check out their progress by downloading the most recent CTP of the Database Publishing Wizard from CodePlex. You'll find information on the site explaining what the tool does and how it works.

Mike