September 15, 2016 at 4:52 am
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
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
>>>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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy