Copy DataBase

[baburk]

How to copy an entire database to another database.

insert into NewTable from select * from oldTable

This copy entire contents from oldTable to NewTable.

Is there is any query to copy a datable contents like this.

Thanks

Babu.R.K

[VijaySofist]

How to copy an entire database to another database.

insert into NewTable from select * from oldTable

This copy entire contents from oldTable to NewTable.

Is there is any query to copy a datable contents like this.

Thanks

Babu.R.K

Hi Babu!

Do you want to copy the full database contents to other database through manually or using some query?

If you want manually means, you can use Enterprise Manager.
Open the Enterprise Manager by Select Programs->Microsoft SQL Server->Enterprise Manager,
Select your SQL Server,
Select the Source Database
Select All the tables and copy those tables
Select your Destination DataBase and Click paste

Now All the tables and its values will be present in your new Database

All The Best

With Regards
Vijay. R

[baburk]

Hi I want it only in QUERY

[camel]

Write an SP that uses Restore Database...With Move from a backup of the old database to create an exact copy of the database on the same server ? Or maybe take copy of detached mdf file and the use sp_attach with new db name

If you are looking to copy the whole of anything but a very small database reliably to another database you would be best looking at a file based approach Trying to use SELECT..INTO, Bulk Insert or even DTS for a whole database just won't guarantee to get all the metadata copied properly, e.g., table constraints, User rights, Roles, etc.