How to Generate Script (with data and Schema) in Sql server using c#

Question

0.00/5 (No votes)

See more:

We just want to generate SQL server database base script having schema & data programmatically using c#.
The SQL server database is in Hosting Server.

Posted 9-Jul-15 21:27pm

Chandra Kant Dubey

Add a Solution

Comments

V Senthil Kumar 10-Jul-15 3:56am

click Generate Scripts and Choose Advanced Setting And Choose TYPE OF DATA TO SCRIPT And SELECT Schemes And DATA ...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

V Senthil Kumar · Answer 1 · 2015-07-09T21:55:00

Solution 1

click Generate Scripts and Choose Advanced Setting And Choose TYPE OF DATA TO SCRIPT And SELECT Schemes And DATA ...

Posted 9-Jul-15 21:55pm

V Senthil Kumar

Comments

Chandra Kant Dubey 10-Jul-15 3:59am

@senthil@Madurai
Not from Wizard I am asking about generating script programmatically using c# no interaction from sql server only from c#.

Wendelius · Answer 2 · 2015-07-09T23:59:00

Solution 2

If you just have the possibility, using SMO (Sql Management Objects)[^] is probably the easiest way. Especially using Scripter class[^].

For example have a look at http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated[^]

Posted 9-Jul-15 23:59pm

Wendelius

Comments

Chandra Kant Dubey 10-Jul-15 7:20am

Sir ! We would like to create script with data and save it on client site. my SQL server is hosted on different server so please suggest me how to generate and how to save generate script at client site.

Wendelius 10-Jul-15 7:41am

It doesn't matter that the server is located on another computer. SMO is a library that can be used in your C# application. using this library you can connect to a remote server.

The only requirement is that SMO is installed on the client or distributed with the application. Have a look at https://msdn.microsoft.com/en-us/library/ff713979(v=sql.105).aspx[^]