May 28, 2008 at 1:17 am
Hi,
Iam having a database PROGDB in one server. I have to copy the entire PROGDB database (including tables, synonyms, sequences, etc) to another server.
Could any one tell me how to copy the database from one server to another server?
Thanks in advance..
May 28, 2008 at 1:51 am
Hi satishkumar.d,
what about using the Copy Database Wizard http://msdn.microsoft.com/en-us/library/ms178396.aspx
[font="Verdana"]CU
tosc[/font]
May 28, 2008 at 2:38 am
The copy database wizard is not shown when i right click in the database. And i don't have sysadmin permission... Could you tell me another way to perform this?
May 28, 2008 at 3:48 am
If your database is not in production then use the detach and attach method.
Detach your database from your source server,
Right Click on db --> Detach Database.
Attach the database to your destination server.
Right click on databases --> attach
May 28, 2008 at 6:03 am
If you do not want to stop the services, you can also just do a backup and a restore.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply