February 1, 2005 at 1:43 pm
what would be the simplest way to go about copying a database from a sql server 6.5 box to a sql server 2000 box? i tried going to the sql server 2000 box, enterprise manager, SQL Server Group, local and then right click on Databases and go to All tasks, Copy Database wizard. but when i try to select the 6.5 server as the source it says it cant connect.
what else can i do?
February 1, 2005 at 2:23 pm
The database from 6.5 could not be copied to SQL Server 2000 or 7.0. It has to be upgraded. It is not an easy or self-explanatory process. You have to read about the implemennting the upgrade. I would suggest Books Online ->Contents ->Installing SQL Server -> Upgrading to SQL Server 2000 -> Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)
I do recomment to read what they say including the very first page "preparing to upgrade"
I would estimate your time as 1 day for the upgrade plan, 2 days for the creating the development environment, 1 day for playing with the upgrade itself (1-machine setup, 2 machine setup....) and depending on the size of the database and your machine at least 2 hours for the production upgrade including all before-upgrade activities
(Updated post) or if you just need data, use DTS to get your tables
Yelena
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply