You may not see an increase of speed when moving to SQL Server. VFP is *very* fast.
As for data/index corruption...if you are seeing it frequently, you should look at the network and application design. I have not seen data/index corruption for a long time.
>We want to increase speed and decrease data/index corruption. I'm not saying I would use SQL Server Express immediately, but I want to know what direction to go in. From what I understand, SQL Server Express is just the next version of MSDE. For what kind of application would MSDE suffice and when would I need SQL Server?
>
>>The SQL Server Express is in beta yet. Why would you want to use it in your application?
>>
>>>I have a large VFP8 application and I'm considering moving the data to SQL Server. When do I need to use SQL Server instead of MSDE/SQL Server Express? i.e. - what are the limitations of SQL Server Express?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer