Select the product you need help with

INFO: Upsize SQL Server 2000 Desktop Engine to SQL Server

Article ID: 325023 - View products that this article applies to.

This article was previously published under Q325023

SUMMARY

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a data engine that is built on and is based on core SQL Server technology.

For an overview of MSDE 2000, visit the following Microsoft Web site:

SQL Server 2000 Desktop Engine
http://msdn2.microsoft.com/en-us/sql/aa336301.aspx

(http://msdn2.microsoft.com/en-us/sql/aa336301.aspx)

MORE INFORMATION

Because your applications may grow beyond the 2-gigabyte (GB) data limit of MSDE 2000, or the application's user base may grow beyond the work load limitation in MSDE 2000, you may have to migrate the MSDE 2000 solution to SQL Server. SQL Server can handle hundreds of concurrent users and databases that grow to sizes beyond one terabyte (TB). By migrating to SQL Server, you can fulfill scalability needs without having to make costly and time-consuming changes to existing applications.

When the time comes to migrate your MSDE 2000 to SQL Server, you have several options:

You can upgrade the existing MSDE 2000 to SQL Server. The SQL Server installation program recognizes an installation of MSDE 2000 and its accompanying data files and transaction logs. This allows you to upgrade MSDE 2000 directly to SQL Server. For more information, visit the following Microsoft Web site:
Upgrading an Existing Installation of SQL Server
http://msdn2.microsoft.com/en-us/library/aa176562(SQL.80).aspx
(http://msdn2.microsoft.com/en-us/library/aa176562(SQL.80).aspx)
You can upgrade from earlier versions to Microsoft SQL Server 2000. You can also perform upgrade operations after you have installed SQL Server 2000. For information, visit the following Microsoft Web sites:
Upgrading from SQL Server 7.0 to SQL Server 2000
http://msdn2.microsoft.com/en-us/library/aa176626(SQL.80).aspx
(http://msdn2.microsoft.com/en-us/library/aa176626(SQL.80).aspx)
Upgrading Databases from SQL Server 7.0 (Copy Database Wizard)
http://msdn2.microsoft.com/en-us/library/aa176630(SQL.80).aspx
(http://msdn2.microsoft.com/en-us/library/aa176630(SQL.80).aspx)
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
303747
(http://support.microsoft.com/kb/303747/EN-US/ )
HOW TO: Install SQL Server 2000 - Basic Local Installation
You can remotely administer MSDE 2000. To do this, point your computer running SQL Server to the computer running MSDE 2000, and then upload the MSDE 2000 data to the computer running SQL Server. For more information, visit the following Microsoft Web sites:
How to Set Remote Server Access (Enterprise Manager)
http://msdn2.microsoft.com/en-us/library/aa177088(SQL.80).aspx
(http://msdn2.microsoft.com/en-us/library/aa177088(SQL.80).aspx)
Remote Access Option
http://msdn2.microsoft.com/en-us/library/aa196726(SQL.80).aspx
(http://msdn2.microsoft.com/en-us/library/aa196726(SQL.80).aspx)
You can detach the MSDE 2000 data file, and then attach it again on a computer running SQL Server. For information, visit the following Microsoft Web sites:
sp_attach_db
http://msdn2.microsoft.com/en-us/library/aa259611(SQL.80).aspx
(http://msdn2.microsoft.com/en-us/library/aa259611(SQL.80).aspx)
sp_detach_db
http://msdn2.microsoft.com/en-us/library/aa933267(SQL.80).aspx
(http://msdn2.microsoft.com/en-us/library/aa933267(SQL.80).aspx)