In a surprise move, Microsoft announced that the soon-to-be released Microsoft Windows Vista operating system and Microsoft Windows Server “Longhorn” will not support earlier versions of SQL Server, including SQL Server 2000 (all editions including MSDE), SQL Server 7.0, and SQL Server 6.5.
SQL Server 2000
Customers running applications with these earlier versions of SQL Server should consider evaluating and upgrading to SQL Server 2005, which was designed to take advantage of the upcoming security and performance enhancements in the operating environment. Visit http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx to learn more about Microsoft’s announcement.
Among the things that you need to consider before upgrading is minimum system requirement. Hardware requirements for SQL Server 2005 are higher than those of SQL Server 2000. Also, SQL Server 2005 requires the .NET Framework 2.0. In terms of features, SQL Server 2005 provides a superior set of features over SQL Server 2000 including database mirroring, CLR integration, database snapshots, encryption, and enhanced XML support.
MSDE
The impact on MSDE users will be greater on Vista since MSDE is a desktop engine. Users of MSDE should consider upgrading to SQL Server 2005 Express, which is the free version of the Microsoft SQL Server 2005 database. SQL Server 2005 Express is built on the same core database engine as the other editions of the SQL Server 2005 product line. It has the same essential data types and programmatic features as the other editions of SQL Server 2005, giving it some important advantages over MSDE. SQL Server 2005 Express runs on the same hardware as MSDE. Recommended system requirements are as follows:
- Processor – A minimum of a 600-MHz processor is required and a 1-GHz processor is recommended.
- RAM – A minimum of 256 MB of RAM is required and 512 MB of RAM is recommended.
- Disk Space – A minimum of 170 MB of free disk space is required, with the Microsoft .NET Framework V2.0 as a prerequisite.
MSDE vs. SQL Server 2005 Express
Although SQL Server Express has a number of new features, some MSDE features are no longer included in the new Express edition of SQL Server 2005. The following table provides a comparison of MSDE and SQL Server 2005 Express:
| Feature | MSDE | SQL Server 2005 Express Edition |
|---|---|---|
| Maximum number of instances | 16 | 16 |
| Maximum number of processors | 2 | 1 |
| Maximum RAM | 2 GB | 1 GB |
| Maximum database size | 2 GB | 4 GB |
| Workload governor | Yes | No |
| SQL Agent | Yes | No (Replace missing SQL Agent) |
| Replication | Merge only | Merge, Snapshot, and Transactional subscription |
| Report Server | No | Yes (Installed with Advanced Services) |
| Full-text search | No | Yes (Installed with Advanced Services) |
Beekeeper Studio는 무료 & 오픈 소스 데이터베이스 GUI입니다
제가 사용해 본 최고의 SQL 쿼리 & 편집기 도구입니다. 데이터베이스 관리에 필요한 모든 것을 제공합니다. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio는 빠르고 직관적이며 사용하기 쉽습니다. Beekeeper는 많은 데이터베이스를 지원하며 Windows, Mac, Linux에서 훌륭하게 작동합니다.
사용자들이 Beekeeper Studio에 대해 말하는 것
"Beekeeper Studio는 제 예전 SQL 워크플로를 완전히 대체했습니다. 빠르고 직관적이며 데이터베이스 작업을 다시 즐겁게 만들어 줍니다."
"많은 데이터베이스 GUI를 사용해 봤지만, Beekeeper는 기능과 단순함 사이의 완벽한 균형을 찾았습니다. 그냥 작동합니다."