Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving to SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00658883
Message ID:
00658914
Views:
21
Hi Randy,

>Hi all, we have an application in MM 7.0 and VFP 7 and would like to move the data to SQL server. I went through the Dev Guide and have the databases upsized into SQL server and connections to each database (we use multiple databases in our app). All databases now have reomte views that work fine. I can create a bizobj in the command window and communicate with SQL fine.
>
>What do I do to get the whole app to use SQL?

The only real thing besides creating and testing the Remote Views (what you already did) ist to turn the Switch !
You really just have to open the preferences form and UnCheck the "Use Local Data" Checkbox. Behind the scenes the System Setting "Data Settings" is changed. Thats it.

>What do I do with the free tables? ie Classess.dbf, MetaDbc.dbf, Metadata ..
>
>Do I leave those on the local machine or put them in a SQL database?
We leave them on the local machine. But really only the few tables
just used by mm. We upsized users.... tables. But this really depends
on your project.

Bye
Marcus
Marcus Alt
TRIA IT-Consulting GmbH
Working hard | for your success
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform