How to generate table script with data using C#

Question

i want to create script for the table with data,i know, how to generate script of table using c#,but i can't get any coding of script of table with data

 StringCollection tableScripts = myTable.Script(scriptOptionsForDependendencies);
        foreach (string script in tableScripts)
            Console.WriteLine(script);

this ways using

Table myTable = myAdventureWorks.Tables["<table name>"]; ScriptingOptions scriptOptionsForDependendencies = new ScriptingOptions(); scriptOptionsForDependendencies.WithDependencies = true; scriptOptionsForDependendencies.DriAll = true; string name = myTable.Name; scriptOptionsForDependendencies.FileName = @"I:\capmanversion\ijob\" + name + ".sql"; StringCollection tableScripts = myTable.Script(); foreach (string script in tableScripts) Console.WriteLine(script); — Nithya sudarsan
– Nithya sudarsan, Commented Sep 13, 2017 at 10:50

Amit Kumar Singh · Accepted Answer · 2017-09-13 11:13:52Z

0

Set scriptOptionsForDependendencies.ScriptData = true. This looks like it will do the work for you.

Put this as scripter.Options.ScriptData = true;

ScriptingOptions sql smo does not support scripting data

edited Sep 13, 2017 at 11:13

answered Sep 13, 2017 at 11:02

Amit Kumar Singh

4,4952 gold badges11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nithya sudarsan Over a year ago

i check this thing but showing error This method does not support scripting data.

Collectives™ on Stack Overflow

How to generate table script with data using C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related