Post reply

How to insert 1GB of Data for all the related tables in SQL Server 2005

  • January 28, 2009 at 2:55 am

    #127693

    Hi,

    I need to generate a script for inserting 1 GB of values in my Database for all the related tables. And the Data which we are planning to insert should be a relevant data, like for example if we are inserting employee details for employee table, need to mention the proper employe information.

    With Regards

    Dakshina Murthy

  • January 29, 2009 at 7:16 am

    #934649

    Hi

    You can use import data wizard in sql server.

    Thanks

  • January 29, 2009 at 7:20 am

    #934653

    You mean you want to a script to generate 1 GB of realistic test data? Or is this for migrating data existing in one DB to be inserted into another?

  • January 29, 2009 at 12:36 pm

    #934992

    Hi,

    If you can export your data in the csv files; you can import it using the osql utility. You can create a batch script which invokes the osql utility.

    Hope this helps.

    Regards

    Meeta

  • January 29, 2009 at 9:15 pm

    #935266

    Hi,

    Thanks for the reply,

    Yes I want a script to generate 1 GB of realistic test data, for a blank Db for testing.

    With Regards

    Dakshina Murthy

  • January 30, 2009 at 2:25 am

    #935341

    I believe you will need a tool like Red Gate's SQL Data Generator. Check: http://www.red-gate.com/products/SQL_Data_Generator/index.htm. Not aware of any opensource/freeware to do this.

    Girish

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply