August 30, 2007 at 9:24 am
Hi, I am new DBA on SQL server database on my new job. Since I started my work on this Monday, I have found that my customers still used MS SQL Server 2000. Now I want to persuade them to upgrade to MS SQL Server 2005. Can somebody provides me with strong arguments so that I could convince them?
Many thanks in advance!
Don
August 31, 2007 at 7:57 am
Hi Don,
There are some excellent new features in SQL Server 2005, like support for CLR, the Service Broker, and support for XML. But at the same time there are many differences between 2000 and 2005. One of them is that objects are no longer owned by users, but are organized into schemas. Also, if your customers have been using SQL Server previously, it is likely that they will have syntax that is from version 6, and that is no longer accepted by SQL Server 2005. So this would mean they will need to rewrite some of their queries. While the Upgrade Adviser identifies many of the problems, your customer need to spend time to change the databases, upgrade, test, etc. (=time and money) If they do not need the new features, you might have difficult time persuading them.
One argument that you may use is that mainstream support for SQL Server 2000 will stop mid 2008, but some security fixes may still be released.
Regards,
Andras
August 31, 2007 at 4:19 pm
Hi Andras,
Many thanks. So far, my clients are quite positive for upgrading SQL 2000 to SQL 2005. All I think is very importamt are to better master SQL 2005.
Don
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply