Need to change back end to SQL

[Tanveer Ishaque]

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]

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/info/product.aspx?view=22&pcid=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

Post by Tanveer Ishaque
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]

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.

Post by Lee Mitchell
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!! --*
http://msdn.microsoft.com/vfoxpro/
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

Post by Tanveer Ishaque
Hi
I have a very large application developed in VFP. Currently I am using a

VFP

Post by Tanveer Ishaque
database. I need to change the back end to a SQL server. I am using VFP

grid

Post by Tanveer Ishaque
extensively in almost all programs. What would be the best way to switch

to

Post by Tanveer Ishaque
SQL Server.
My application runs smoothly in VFP9.
Thanks in advance.

[Kurt Grassl]

Post by Tanveer Ishaque
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

[Craig Berntson]

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/en-us/dnarfoxgen/html/msdn_bko01.asp
http://msdn.microsoft.com/archive/en-us/dnarfoxgen/html/msdn_fpsqlcs.asp
http://msdn.microsoft.com/archive/en-us/dnarfoxgen/html/msdn_bko02.asp
http://msdn.microsoft.com/archive/en-us/dnarfoxgen/html/msdn_usevfp.asp
http://msdn.microsoft.com/library/en-us/dnfoxgen/html/adojump.asp
http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_embeddingmsde.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

Post by Tanveer Ishaque
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.