>I guess my question really is; with the limited description I have provided you with of our current conversion and upsizing strategy; what would your prediction be when it comes down to the feasbility and/or over all performance of the end result of upsizing this table structure to SQL server 2k for a production Call center and CRM database being used by just short of a 1000 users at a time???
With a system of that size, you should spend a LOT of time designing this upgrade. Just moving the tables as-is will more than likely do nothing for performance, and could hurt it. I just finished a large upgrade from vfp to sql, and we spent hours upon hours discussing what we needed to do. We then spent approximately 3 months converting and testing code, doing multiple conversions of the data and checking results, etc.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown