FoxPro database connector - Need to change back end to SQL

Author

Need to change back end to SQL

Tanveer Ishaque

2005-11-08, 4:16 pm

Hi

I have a very large application developed in VFP. Currently I am using a VFP
database. I need to change the back end to a SQL server. I am using VFP grid
extensively in almost all programs. What would be the best way to switch to
SQL Server.

My application runs smoothly in VFP9.

Thanks in advance.

Lee Mitchell

2005-11-08, 4:16 pm

Hi Tanveer Ishaque:

Can you tell us a little bit more about how your application is designed?
Are you using local views to populate your grids? If so, then simply
change these to remove views that point to your SQL Server data. Since you
have VFP 9.0, you can also use cursoradapters to connect to SQL Server.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Hi

>I have a very large application developed in VFP. Currently I am using a
VFP
>database. I need to change the back end to a SQL server. I am using VFP
grid
>extensively in almost all programs. What would be the best way to switch
to
>SQL Server.

>My application runs smoothly in VFP9.

>Thanks in advance.

Craig Berntson

2005-11-08, 4:16 pm

The effort could be as simple as creating remote views instead of local
views or it could be a major retrofit effort, depending on how you've
written your code.

In addition to the VFP docs, here are some places to get started. Some of
these articles are a bit dated and talk about some technologies that are no
longer used (RDS for example), but still contain some good information.

http://msdn.microsoft.com/archive/e.../msdn_bko01.asp
http://msdn.microsoft.com/archive/e...sdn_fpsqlcs.asp
http://msdn.microsoft.com/archive/e.../msdn_bko02.asp
http://msdn.microsoft.com/archive/e...msdn_usevfp.asp
http://msdn.microsoft.com/library/e...tml/adojump.asp
http://msdn.microsoft.com/library/e...beddingmsde.asp

There are some sample chapters you can download from
http://www.hentzenwerke.com/catalog/csvfp.htm

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net

"Tanveer Ishaque" <tanveer@creativepk.com> wrote in message
news:OgI5TW54FHA.2364@TK2MSFTNGP12.phx.gbl...
> Hi
>
> I have a very large application developed in VFP. Currently I am using a
> VFP database. I need to change the back end to a SQL server. I am using
> VFP grid extensively in almost all programs. What would be the best way to
> switch to SQL Server.
>
> My application runs smoothly in VFP9.
>
> Thanks in advance.
>
>

Tanveer Ishaque

2005-11-08, 4:16 pm

Thank you very much.

I tried cursoradapters and they work fine.

I am using the normal file handling commands to manipulate data for which I
need several indexes. I have seen that I can create 'Index Tags' during run
time which is taking a little time. Is there a way I can define 'Index Tags'
for cursoradapters during design time.

Thank you again.
Tanveer Ishaque.

"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:%232NP2k64FHA.3936@TK2MSFTNGXA01.phx.gbl...
> Hi Tanveer Ishaque:
>
> Can you tell us a little bit more about how your application is designed?
> Are you using local views to populate your grids? If so, then simply
> change these to remove views that point to your SQL Server data. Since
> you
> have VFP 9.0, you can also use cursoradapters to connect to SQL Server.
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/i...cid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>
> VFP
> grid
> to
>
>
>
>

Kurt Grassl

2005-11-08, 4:16 pm

>
> I am using the normal file handling commands to manipulate data for which
> I
> need several indexes. I have seen that I can create 'Index Tags' during
> run
> time which is taking a little time. Is there a way I can define 'Index
> Tags'
> for cursoradapters during design time.

AFAIK: no, but you can make your own CursorAdapter-class with this
functionality. It's always a good idea to subclass VFP-baseclasses rather
than using them "directly".

hth
Kurt

Sponsored Links