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 È Una GUI per Database Gratuita e Open Source
Il miglior strumento per query SQL ed editor che abbia mai usato. Fornisce tutto ciò di cui ho bisogno per gestire il mio database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio è veloce, intuitivo e facile da usare. Beekeeper supporta molti database e funziona benissimo su Windows, Mac e Linux.
Cosa Dicono Gli Utenti Di Beekeeper Studio
"Beekeeper Studio ha completamente sostituito il mio vecchio workflow con SQL. È veloce, intuitivo e rende di nuovo piacevole lavorare con i database."
"Ho provato molte GUI per database, ma Beekeeper trova il perfetto equilibrio tra funzionalità e semplicità. Funziona e basta."