Post reply

How to generate SQL Insert Script?

  • July 30, 2005 at 3:44 am

    #60856

    Hi All,

    I have 2 databases. One in Access and another in MS SQL Server 2000.

    DTS Import Export wizard transfers the data between Access and SQL Server well. I am able to get the SQL Scripts for "Create Table", but How to get the SQL Script for "Insert Into Table ..." ?

    Can any one please help me out to solve this problem?

    Thanks a lot in advance,

    Regards,

    Jignesh

  • August 1, 2005 at 1:22 pm

    #578654

    In the Query Analyzer Object Browser, right-click on the table, choose 'script object to new window(or file, or clipboard) as insert'.

    Greg

    Greg

  • January 31, 2006 at 12:44 pm

    #617994

    Try http://www.sqlscripter.com to generate your data script. All types are supported (Insert, Update, Delete).

    It's free.

    -Thomas

  • February 23, 2006 at 6:32 am

    #622893

    And also DB Ghost with its Data and Schema Scripter.

    I'd cry, but I can't stop laughing.

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

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