Downside of SQL Server 2005?

Question

im writing a work report abou8t upgrading the company database platform from SQL server 2000 to SQL Server 2005-Ive got plaenty of postive points but what about negative points- i.e reasons for me to not upgrade-please provide your sources too so that i can reference it in my report

Answer 1

As with upgrading any database - you need to be concerned about the applications that are tied to it. If you have and customized applications, then there will likely be some development costs to update the applications (database connectivity). If you use MS Access to perform any administration - it's not possible to create a Access project (.adp file) connected to SQL Server 2005 just yet. Other compatibility issues would need to be evaluated such as reports (like Crystal reports). These may also require redevelopment to change over to the new server settings. As far as data conversion - there are no issues that I've seen yet - but that is influenced by database architecture. With sufficient planning and identifying all the various affected applications - you shouldn't really experience too much of a problem.

Answer 2

They have one version of SQL Server 2005 that's free - the SQL Server 2005 EXPRESS EDITION. I have that on my home PC and it works great with my Access XP databases.

Answer 3

The main reason is MONEY!



No negative impact on Server 2005. Other than renewing licsence .



Another thing is paying developers training. You have to train your developers using that product.



So yes the main reason would be the cost of buying, training and licenses



hope it helped



You could write up a big report on this..



FYI he cannot use the EXPRESS edition. It is only for home use not production use and training use...

Answer 4

Go for Oracle database, its the best for a growing database. Very flexible, robust,versatile, saves time and cost in the lng term.