Re: VFP 9/SQL Server Integration Question

What Dan said is all true. But be aware that the process will not be as
transparent as you might wish. Of course it can be done, and Microsoft has
put a lot of effort into making it as easy as possible. But switching from
using VFP tables directly to using views, then switching your views to use
MSSQL data instead, is not always a trivial exercise.



"Dan Freeman" <spam@xxxxxxxxxxxxx> wrote in message
news:OP7sdW6wFHA.2792@xxxxxxxxxxxxxxxxxxxxxxx
> It's not endemic to VFP9. You can do it in VFP6 too! Take a look at the
> help
> file entry on Remote Views.
>
> Now, the whole "Zen" of application development changes when you move to a
> back-end server. So this is a bit of an oversimplification but you can
> switch a remote view for your DBF in a form's data environment and you're
> there. A remote view (or local view) behaves exactly like a table. You can
> USE it, SCAN it, LOCATE in it, REPLACE in it, etc.
>
> Remember that Zen thing? The goal when you're dealing with SQL Server (or
> any back end) is to only include in your views the data that's necessary
> for
> the task at hand. That's where parameterized views come in. You only bring
> the data across the wire that you need *right now*.
>
> For a good book on this topic (written in the VFP6 timeframe even, I
> think)
> go visit hentzenwerke.com and look for "Client-Server Applications" (or
> something approximately like that) in their catalog.
>
> Dan
>
> Mike wrote:
>> Hi. I have several VFP 6 applications which I want to keep in FoxPro
>> but I want to move the databases to SQL Server. I've heard that VFP
>> 9 allows you to interact with SQL tables using FoxPro database
>> commands, allowing for a more seamless transition to SQL Server.
>>
>> For example-
>> If I have a FoxPro DBF named TABLE1, and I currently issue the
>> statement "USE TABLE1" to use the table, can I create a SQL table
>> named "TABLE1" (with the same data structure, etc) and be able to
>> interact with that table by still issuing the "USE TABLE1" command?
>>
>> Thanks.
>
>


.

Relevant Pages

  • Re: Can I disable View Designer syntax checking?
    ... > I have a remote view into a SQL Server back end. ... > above query in and try to save the view, FoxPro complains that I have too ...
    (microsoft.public.fox.programmer.exchange)
  • Can I disable View Designer syntax checking?
    ... I have a remote view into a SQL Server back end. ... above query in and try to save the view, FoxPro complains that I have too ...
    (microsoft.public.fox.programmer.exchange)
  • Re: TS vs VPN
    ... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
    (microsoft.public.windows.terminal_services)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)
  • Re: Remote Database Connection with PocketPC/MSAccess Front End
    ... If you want to allow direct remote access for your Access data, I'd suggest writing a web service which your remote apps could use. ... The general problem with mobile access to remote data of any kind (including SQL Server which Windows Mobile devices can access directly remotely) is that sometimes the connection just isn't there. ... Generally the easiest backend data store to use for this local cache is going to be SQL Server Compact, which supports several sync strategies including the Access Sync Services that your question isn't about. ...
    (microsoft.public.pocketpc.developer)
Quantcast