Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE vs. SQL Server
Message
From
06/07/2004 10:03:04
 
 
To
05/07/2004 17:34:08
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00920822
Message ID:
00921012
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform