August 8, 2008 at 6:37 am
Since SQL Server 2008 is finally here, I wonder if I can install it along with SQL Server 2005.
BTW can anyone tell me what is the difference between 2005 and 2008? Is there a big learning curve liked moving from 2000 to 2005?
August 8, 2008 at 6:58 am
Loner (8/8/2008)
Since SQL Server 2008 is finally here, I wonder if I can install it along with SQL Server 2005.BTW can anyone tell me what is the difference between 2005 and 2008? Is there a big learning curve liked moving from 2000 to 2005?
While SQL Server 2008 introduces many new features (overview on http://www.microsoft.com/sqlserver/2008/en/us/overview.aspx), they are not as intrusive as the ones introduced by 2005. There is only one new object type, database objects are organized the same way, system tables/views mostly the same. The new features do not require you to change anything you know already.
Regards,
Andras
August 8, 2008 at 8:59 am
I do agree. Most of what you're doing in 2005 and most of the way you do it, should remain the same. The one area that I think might bite people is that 2008 finally and completely drops the ANSI 89 join syntax. No more *= or =*.
Other than that, if you know 2005, then you can begin selectively applying 2008 functionality without too much trouble.
"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
August 8, 2008 at 9:20 am
To use it, no. As mentioned, it's close to 2005, but with stuff added on. As you get into new features (PBM, resource governer, compression, etc.), there are things to understand that may take some time, but you don't need those right away.
August 15, 2008 at 1:28 pm
You can install alongside. I just finished doing exactly that.
The learning curve is pretty shallow from 2005 to 2008.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 18, 2008 at 5:13 am
I'm running it side-by-side with 2005. One of my co-workers has 2000, 2005, and 2008 all running on his personal machine with no issues from any of them. The same couldn't be said of the beta though. I had to completely reinstall everything on my lap top after messing up and installing the beta.
"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
August 18, 2008 at 7:41 am
Virtual PC is free, I'd recommend running it in a VM to be safe. The RTM is probably fine, but you don't want to create issues with your current environment.
August 19, 2008 at 4:58 am
There are 2 parts in using SQL Server 2008, both of which will take some time getting used to:
* Using the database engine, AS, RS, etc
* Using the client tools
The SQL Server 2008 tools are great for managing SQL Server 2005. I recommend getting your administration servers upgraded to the SQL Server 2008 client tools, and use the new version of SSMS to manage your older SQL Server instances. That way you get part of your learning curve done with less impact on day to day operations, and without having to wait until your aplications have been verified to work with SQL Server 2008.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 19, 2008 at 8:09 pm
As I read on some blog:
SQL Server 2008 = SQL 2005 with Big Service Pack :hehe:
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply