[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Upgrade to SQL 2005?

I have a client that is upgrading an accounting package that is currently installed on Windows 2003 SBS Premium and is using SQL 2000. The new accounting upgrade supposedly works in SQL 2000 or 2005.  Would there be any advantage or reason to upgrade to SQL 2005?  Would that be done by adding SQL 2005 to the SBS or would we just upgrade to SBS R2?
Thanks
0
baggio8
Asked:
baggio8
1 Solution
 
DantheDBACommented:
At this point there may not be an advantage to upgrading to SQL2005.

It is a superior piece of software in that it has additional features,  but at the same time it is more resource intensive (especially on tempdb). If it will just be the backend for another piece of software you may not need those additional features.

In the longterm it is good to upgrade the software for future compatibility (i.e. the next version of your accounting software may not support SQL2000).

If you are to choose the path to upgrade you wouldn't necessarily need to upgrade to SBS R2, although that would be a good idea. You would want to install or upgrade SQL 2000 to 2005.

Microsoft has some migration paths on MSDN that could guide you through this process. http://msdn2.microsoft.com/en-us/library/ms144245.aspx
0
 
baggio8Author Commented:
DantheDBA,As it turned out I had to update to SQL 2005 for the requirements of the accounting package.  The free standing copy of SQL 2005 for Workgroups was $1499, but the upgrade to SBS R2 was only $699.  Obviously I chose the SBS R2 upgrade.  Thanks for your comments.

Jon
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now