October 18, 2007 at 6:09 am
Hello everyone!
As new user and also beginner of SQL I wanted to know how to copy database from SQL 2000 to SQL 2005! What can I do and what are the steps to make good copy!
No metter for the application I'm asking just the database!??
THnx!
October 18, 2007 at 6:51 am
Hi,
Well .. the easiest and most reliable way is to create the empty SQL 2005 database and then right click it .. Tasks .. Copy Database wizard.
I hope that helps
Osama
October 18, 2007 at 10:39 am
Also consider making a backup of the SQL 2000 database and restoring it in the SQL 2005 instance.
Greg
Greg
October 19, 2007 at 12:35 am
I find the solution Detach database from SQL 2000 and Atach database to SQL 2005!
But I wanted to ask for the best solution!
So I'm looking why the application doesn't work, also it has the tool to change the connections with database...but doesn't work! Searching the problem and contacting with Appl Developer!
Thnx anyway!
October 19, 2007 at 1:02 am
you can do so by means of Using the Copy Database Wizard. plz browse the following link and try to implement according to your own functionality needs.
October 19, 2007 at 2:08 am
VAIYDEYANATHAN.V.S (10/19/2007)
http://technet.microsoft.com/en-us/library/ms188664.aspx%5B/quote%5D
Nice Info thnx!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply