locked
Generate Script With Data RRS feed

  • Question

  • 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 

    Thursday, May 10, 2007 6:52 AM

Answers

All replies

  •  

    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

    Thursday, May 10, 2007 8:14 PM
  • 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

     

    Thursday, May 10, 2007 9:19 PM
  • 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.
    Friday, May 11, 2007 9:58 AM