Post reply

Create Auto Insert Script - 500k records to load data into sql server

  • June 20, 2017 at 7:28 am

    #402197

    Hi,

    I would like to Create Auto Insert Script - 500k records to load data into sql server for my testing.

    How can i generate dummy table and data script?

    I have sql server 2008 and 2012 version.

    Thanks

  • June 20, 2017 at 7:33 am

    #1947373

    Jeff Moden did some articles on this. Start here and see how you get on.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • June 20, 2017 at 7:57 am

    #1947379

    Actually I need to Createa simple CSV and upload it to sql server and OR other application.

    Your help really Appreciated it!

    Thanks.

  • June 20, 2017 at 8:08 am

    #1947382

    poratips - Tuesday, June 20, 2017 7:57 AM

    Actually I need to Createa simple CSV and upload it to sql server and OR other application.

    Your help really Appreciated it!

    Thanks.

    Use Jeff's technique to create a dummy table, and then use BULK EXPORT to output the data to a CSV file.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • June 20, 2017 at 8:19 am

    #1947385

    poratips - Tuesday, June 20, 2017 7:28 AM

    Hi,

    I would like to Create Auto Insert Script - 500k records to load data into sql server for my testing.

    How can i generate dummy table and data script?

    I have sql server 2008 and 2012 version.

    Thanks

    what data columns and datatypes are you intending to create?
    do have specific data ranges that need to be addressed?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • June 20, 2017 at 9:31 am

    #1947398

    Thanks.
    I need just number, data and varchar type but it will be ok any kind of data as i am testing connectivity.

  • June 20, 2017 at 9:36 am

    #1947402

    poratips - Tuesday, June 20, 2017 9:31 AM

    Thanks.
    I need just number, data and varchar type but it will be ok any kind of data as i am testing connectivity.

    so why the need for 500k records?
    just knock something up in excel and save as csv?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

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

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