>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.