Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor Adapter is the way to go?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01229649
Message ID:
01229653
Views:
13
>My application is built with DBFs
>
>I want to upsize it to SQL Server ... and be able to have the DBF version still working.
>
>I don't know anything about cursor adapters. Would the use of cursor adapters make what I want to do possible?
>
>Would I be able to make an application that would work either with DBFs or Client-server architecture?

I have several apps that work with either DBF's or SQL Server.

The way I did it:
1. When you create your .dbf's, make sure the sturcture will work in SQL Server too. (For example, no date fields, no time fields, use only datetime fields)
2. Make another DBC and put nothing but remote views in it to connect to your DBF's. You'll want to use remote views for your entire application.
3. Upsize your dbf's to SQL Server. (If you designed them correctly, NO structure changes will need to be made).
4. Now, if you want to use SQL Server instead of DBF's, all you have to do is change the connection string in the .dbc with the remote views to point to the SQL Server instead of the .dbc with the tables in it.

This is really a pretty cool way to do it. To change from DBF's to SQL Server you dont even have to recompile.
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform