May 20, 2011 at 3:36 pm
In many situations, I just want to grab one or two rows from a table and script out the inserts. It would be nice if SMO did this for me automatically, including handling whether to generate "set identity_insert [schema].[table_name] on/off" lines.
I can't use the traditional way to dump table data:
ScriptingOptions.ScriptData = true
This option scripts out EVERYTHING. I just want one row, e.g. the row where a PK equals 0.
What's the best way to do this?
May 23, 2011 at 3:45 pm
Hello,
I am sorry , but , with my poor english, i am not sure to have fully understood your question.
I am using SMO since the release of SQL Server 2005 SP2 ( before SMO was often incomplete or with bugs ).
To get the results of a query ( SElECT mainly ) , i am relying on the SqlClient namespace ( so .Net Framework ) and for the SqlConnection necessary to create a SqlCommand , i get it from the SqlConnectionObject property of Server.ConnectionContext.
I have some doubts to have understood your hypothesis about primary keys with a value of 0. Please, could you tell us whether you want to create a primary key on a column having already values ? If yes, you cannot create a primary key on a column if you have several rows with the same value.
But, it is possible that i have not understood your question ( usually, i can translate english in french, but french into english , really difficult for me and i hope you will excuse me ).
Have a nice day
May 23, 2011 at 4:26 pm
It's ok. I solved the problem by avoiding it. Using SMO was an experiment and a bad idea for this problem. Wrong tool for the job.
May 22, 2015 at 12:21 pm
Hi, Can you provide the script for insert script for all table data? Thanks
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