2008 or 2005 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

2008 or 2005

Author

Topic

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2008-08-28 : 15:54:46

We are going to upgrade an are puchaseing SQL 2008.
Uprgading from 2000 should we upgrade to 2005 first?

I know I need to convert about 20 DTS packages to jobs.
And replace another 20 SQLmail instances with DB mail.

Total Size of all DBS around 6GB

Recomendatons?

Jim
Users <> Logic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-28 : 15:56:32

2008.
same price as 2005 so why cut 3 years off product support... plus tons of new features, improvements and other stuff.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2008-08-28 : 16:02:39

I believe he is asking whether or not you can go straight from 2000 to 2008 or if you have to upgrade to 2005 first and then to 2008.

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2008-08-28 : 16:05:35

We are buying the 2008

But it gives us the right to install 2005 and then upgrade to 2008.
The question is Should we?

Jim
Users <> Logic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-28 : 16:07:08

well you can just backup the databases and restore them on 2008. i don't know about updating servers... i'd think you'd get new servers for 2008, no?

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2008-08-28 : 16:09:30

Yes I am Getting a new server.

Jim
Users <> Logic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-28 : 16:25:20

then install directly 2008. forget the upgrade.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources