Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Move to 2005

Author  Topic 

vavs
Starting Member

24 Posts

Posted - 2010-09-09 : 09:25:15
I have both SQL 2000 and SQL 2005 databases on my server. I have Enterprise Manager installed for 2000 but do not have the Management Console for 2005. Can I install the management console and then move the 2000 database to 2005. I need to use some of the features of the 2005 version.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-09-09 : 10:00:54
Yes, but note that you will not be able to move the databases back to 2000 afterwards. You should also do some serious testing to ensure that none of the changes in 2000-2005 break your app.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -