05-28-2007, 12:13 AM
Knows Where the Search Button Is
Join Date: Nov 2005
Post Thanks: 0
Thanked 0 Times in 0 Posts
| | Upgrade MSDE 2000 to SQL Server 2000 (locally)
Please Login to Remove!
Has anyone out there upgraded there existing MSDE 2000 database on their BES to SQL Server 2000? I've found heaps of articles referring to upgrading the database to a remote SQL Server, but not locally. Is it as simple as installing SQL Server 2000 on the BES, & having the installer detect that there is an MSDE database running, and then prompt to upgrade the MSDE database to a full SQL Server databse?
Also, would I need to upgrade MSDE 2000 to to the same SP as the full version prior?
Any assistance would be appreciated.