Complete script of database using c#

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to generate script of database with schema and data using c#. I am able to get the script for individual portions like table , storedProcedure ... but it is not a good way.

Can anyone please suggest a good method for doing it.

Thanks.

Posted 16-Aug-13 3:54am

Ariana Bond

Add a Solution

Comments

joshrduncan2012 16-Aug-13 9:56am

What do you mean by "not a good way"?

Ariana Bond 16-Aug-13 10:00am

I mean if i am getting scripts of individuals then obviously i have to merge it into one file which will consume some resources. I would like it in the way, a single file is generated.

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-08-16T04:48:00

Solution 1

Refer - SMO scripting entire database like Studio Management does with Generate Scripts[^].

Quote:
Have a look at http://scriptdb.codeplex.com.
This is a tool that scripts out a Database's ddl.
For Scrripting out the data you could try an approach like described here: http://sqlblog.com/blogs/ben_miller/archive/2007/10/18/scripting-tables-views-and-data-using-smo-part-3.aspx or try to use bcp, wich would be the better alternative for bigger databases.

Posted 16-Aug-13 4:48am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Ariana Bond 16-Aug-13 10:52am

I would like to have my program rather to use free tool.

fjdiewornncalwe 16-Aug-13 12:10pm

Then you can download the source from codeplex and figure out how it was done and implement it on your own.

Ariana Bond 16-Aug-13 12:27pm

Hi Marcus,
I am getting this error when tried to script all objects.
Cannot script the object with Urn='Server[@Name='Example']/Database[@Name='DatabaseName']/ServiceBroker'.
If you have any idea then please help me.

fjdiewornncalwe 16-Aug-13 12:43pm

Basically telling us "It doesn't work" doesn't really provide any information that we can help you with.
You'll have to use your debugger to step through the code and find where the code fails.

Ariana Bond 16-Aug-13 12:51pm

I am creating alist of URN's while scripting the objects , but when Service Broker turn comes scripter.script () method throws exception "Failed Operation Exception".

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 18-Aug-13 3:17am

Exactly... :)