Moving SQL 2000 to SQL 2005
We started to use Database servers on our local machines at work recently and we decided to go with SQL 2005. The production and development servers we have are all SQL 2000. Being workstations and laptops we decided that SQL Express would be the most appropriate version for the machines as it is stripped down and uses less resources. Unfortunately because it is a cut down version it doesnt have the capability to upgrade a SQL 2000 database to SQL 2005. You get some useful error like this:
Thankyou Bill. After some searching with no fruit we were able to get hold of a SQL 2005 developer edition, and this was much better. Now it was simply a case of taking the SQL 200 MDF file and attaching it on the SQL 2005 server. It does some clickking and whirring et voila you are now a fully funcitoning 2005 user. After this we pushed the mdf file across to the other users local machines that were running Express.