Call Center Outsourcing Problem
I was wondering if anyone could tell me what's the difference between SQL
6.5 and 7.0? I run a call center Outsourcing and the fifteen or so agents
use software created from VB6 that currently pulls from a SQL 6.5 database. In this
situation, time and speed are of the essence. Also, I am thinking about
creating another database for the administration and also running it from
SQL. There are about 30 people in administration that would need access to
it. I was hoping if someone could explain the new features of version 7 and
if it would be worth it to upgrade. Also, is the upgrade difficult, because
I don't want to shut down my call center for very long. Costs are not a
consideration on this one.
Check out the What's New section of the SQL Server 7 documentation. This is
available at
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/8....
htm
I found upgrade to be fairly simple but you should definitely try it out in
a test environment before upgrading your production server. The speed
largely depends on your database sizes.
I have only good thing to say about SQL 7. You also may want to consider
going to directly SQL 2000.