Post reply

SQL Server 2008 Task generate script

  • September 15, 2016 at 4:52 am

    #317414

    I am using Task > Generate script to create a sql insert script.

    Is there any way I can change table name while generating insert script ?

    I was looking at Advanced > Options ...but could not find anything.

    Is there anything I'm missing ?

    Example:

    source table say TEST

    I want generate script to make a table TEST_TEMP

  • September 15, 2016 at 4:56 am

    #1901062

    Not as far as I know. But you could manually amend the script as soon as it's generated. Or you could write your own query to return an INSERT statement for whatever table name you choose.

    John

  • September 15, 2016 at 5:41 am

    #1901071

    >>>you could write your own query to return an INSERT statement for whatever table name you choose.

    Could not get it. are you saying not to use generate script

  • September 15, 2016 at 7:07 am

    #1901101

    I'm saying that's one option, yes.

    John

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

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