Post reply

Populating tables on install

  • January 24, 2006 at 4:39 am

    #167144

    Hello all, I am going to run a script to install my tables onto my SQL server. I would like to populate some of the tables with values when the script is run (dropdown tables, default values table etc).

    How should I do this?

  • January 24, 2006 at 5:43 am

    #616625

    Generally when I have seen this done in repro scripts and the like you just code some INSERT statements with your fixed valuess. If you have lots of data you could look at bcp.

  • January 25, 2006 at 7:26 am

    #616898

    Google for:  SQL insert script generator

    You will find numerous tools that will generate the insert statements for you.

    Unless you like keying them out by hand....

    hth jg

     

  • January 31, 2006 at 1:02 pm

    #618002

    Try http://www.sqlscripter.com to generate your data scripts.

    -Thomas

Viewing 4 posts - 1 through 3 (of 3 total)

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