How to create new database using a old one in sql server 2005 from C#?

Question

2.67/5 (3 votes)

See more:

hi there,

How i can create a new database and make new log and mdf files copying some data from old one and i have to do this from C# and also copy some dotnet exe from the folder of my choice.

please help me.

Posted 1-Jan-12 19:58pm

Nirmala Saravanan

Updated 1-Jan-12 21:04pm

thatraja

v2

Add a Solution

Comments

OriginalGriff 2-Jan-12 3:46am

Reason for my vote of one: too lazy to use google.

Amir Mahfoozi 2-Jan-12 10:17am

You can attach to that deployed database.

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)

Wendelius · Answer 1 · 2012-01-02T11:17:00

Solution 2

If you need to get the data from an old database and using that create a new one, two perhaps easiest ways are:
- Take a BACKUP[^] and then RESTORE[^] it as a new database
- Detach the database, copy it and attach it to somewhere else. See: Detaching and Attaching Databases[^]

Posted 2-Jan-12 11:17am

Wendelius

Comments

Espen Harlinn 2-Jan-12 19:03pm

Good advice :)

Wendelius 3-Jan-12 0:24am

Thanks :)

OriginalGriff · Answer 2 · 2012-01-01T21:45:00

Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

A very quick search using your subject as the search term gave these three as the top links:

Create a SQL Server Database Using C#[^]
Create a SQL Database Programmatically[^]
How To Create a SQL Server Database Programmatically by Using ADO.NET and Visual C# .NET[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.