Upgrading from MSDE 2000
to SQL Server 2005 Express Edition
IssueView has long provided MSDE, the free version of SQL Server
2000. You can upgrade your MSDE installation to SQL Server 2005 Express
Edition, the free version of SQL Server 2005. SQL Server
2005 Express Edition doesn't have any limits on the number of users
that can access the database. Instead, it limits the database size to 4
GB, available RAM to 1 GB, and the SQL Server executable to
running on 1 CPU. Chances are these numbers all represent an
increase over your current capacity.
The process is simple, and will preserve your existing IssueView
database, including all data and configuration information. While you
don't have to log off all of your users, they will be disconnected from
the SQL Server during the upgrade process. Here are the steps:
-
On the machine where MSDE is currently installed, download and
run the Express
Edition Installer. It will
require that you install the Version
2.0 .NET framework if it is not already on the machine.
-
You can accept the default settings for the first few setup screens
(Installing Prerequisites, Welcome, and System Configuration Check)
-
When you reach the 'Registration Information' screen, you need to
uncheck 'Hide advanced configuration options', then click Next
-
You can accept the defaults in the 'Feature Selection' screen, or
take this opportunity to install some additional SQL Server management tools.
-
In the 'Instance Name' screen, select 'Default Instance'. This
is necessary to upgrade your default MSDE 2000 installation.
-
Next you'll come to the 'Existing Components' screen. It will
have an existing SQL Server version displayed but not checked.
Check the existing version to indicate that you want to upgrade
it.
-
After this you can just accept the defaults and complete the setup.
When the setup completes, your MSDE 2000 software will have been upgraded to
SQL Server 2005 Express Edition. You won't see any difference in
IssueView when you log in.
|
