how to create database

Question

0.00/5 (No votes)

See more:

Can anyone help me how to create database with the same data(existing in some database),While i am trying to create Database it shows error "same data will be in some database"
eg: Existing database is KK
New database is KKA

Posted 20-Dec-13 7:26am

Karthik Achari

Add a Solution

Comments

joginder-banger 20-Dec-13 13:39pm

means you can try backup restore in database.

Jörgen Andersson 20-Dec-13 15:44pm

You should have stated what database you're using.

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)

cigwork · Answer 1 · 2013-12-20T07:38:00

If you want a copy of the DB the simplest solution is to backup the first DB and then restore the just created backup under a different name.

For SQL Server:
Can all be done from the Object Browser in SQL Server Management Studio.

Can also be done from T-SQL. See:

Restore:
http://technet.microsoft.com/en-us/library/ms190447%28v=sql.105%29.aspx

Backup:
http://technet.microsoft.com/en-us/library/ms191304%28v=sql.105%29.aspx

Other DB engines will have similar facilities.

Peter Leow · Answer 2 · 2013-12-20T07:44:00

Solution 2

Check this out:

Copy SQL Database Wizard

You can select your database version from the top link of the page.

Posted 20-Dec-13 7:44am

Peter Leow

Updated 20-Dec-13 7:48am

v2