Generate Script With Data

Hi,

Can Anyone tell me how to generate script with all table data from one database.I can generate script with table structure but not with table data.I want to generate with Table data.

Thanks,

Pavan

If you want to take the data with the tables would it not be easier to do a backup and restore of the data?

Or use Sql Servers import functionality to simply import the tables and data you require?

Can you give us more info on this? such as, are you trying to take just single tables over into an existing database? or are you creating a new database?

Do you want all the tables or just a subset of them?

Thanks

Pete

|||

The Database Publishing Wizard will help you script out the data):

DDL –Script Data to file (Database Publishing Wizard)
http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&DisplayLang=en

|||I used to write a simple .NET/VB app to do this - extract data from my database tables and generate a text file which contains INSERT statements which can be run together with the script generated for the database schema. Good thing there is this tool available now.