June 7, 2011 at 7:45 pm
I developed a couple systems several years ago using SQL Server 2000. They are both still in production. The client wants me to be part of a rewrite. I have a couple months to get refamiliar with the system and what was done.
I tried to load SQL 2000 Developer on my Windows 7 machine but it isn't compatible. I downloaded 2008 Express. If I recall the "express editions" did not have "Enterprise Manager," although maybe 2008 is only using "Management Studio?"
I also have a full edition of SQL 2005 I just found, forgot I had it, never loaded it.
Questions:
Is Management Studio the replacement for Enterprise Manager?
Can I use SQL 2005 on Windows 7; assuming 2005 has Enterprise Manager?
Should I just buy a SQL 2008 Developer's edition for this project? I'm not going to be the programmer, simply want this app on my laptop so I can get familiar with it again. It is a pretty big application, lots of stuff going on.
June 7, 2011 at 7:51 pm
http://en.wikipedia.org/wiki/Enterprise_Manager
OK, looks like Enterprise Manager went away in SQL 2005.
New question:
Other than database size issues, is the Express version totally functional? Thanks.
June 8, 2011 at 6:01 am
Express does cover the fundamentals of the SQL Server relational engine very well. You can learn querying, basic maintenance, backups and restores, tuning, pretty much all you need. If you want to start learning more, SQL Agent, Replication, Mirroring, Data Collector, etc., I'd suggest spending the $50 and picking up a developer's copy of SQL Server. You can get them directly from Amazon.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply