Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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
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
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:
(http://support.microsoft.com/kb/290623/EN-US/ )ACC2002: How to Attach an Existing SQL Server 2000 Database to SQL Server 2000 Desktop Engine
(http://support.microsoft.com/kb/224071/EN-US/ )Moving SQL Server Databases to New Location with Detach/Attach
(http://support.microsoft.com/kb/314546/EN-US/ )HOW TO: Move Databases Between Computers That Are Running SQL Server