>Hi,
>
>I using FVP6.0 and call database with .dbf and .cdx
>
>I want to know, are those guys had change to use VFP7/8
>and SQL Server.....
>
>is't easy to install and use ?

Yes. What you are asking is called Client/Server. There is information on this in the Help files.

You should also read about the use of Remote Views and of SQL Pass-Through (both detailed in the help files).

In VFP8 you have an easier and powerful new opbject: Cursor Adapter that makes it easy to access SQL Server data through ODBC, ADO nd OleDb and also XML.

As for how easy it would be to change your existing applciation, it depends on its architecture and data model. If it is a standalone, one-tier EXE, whith DBFs opened directly in the Data Environment of each form, then it will not be easy. A lot of work is involved.

If on the other hand, your app is designed as multi-tier, then it might be very easy to switch your data base to SQL Server.

One two-tier, fairly simple way of switching is if you use local views instead of talking directly to DBFs. In this case (which depends obviously on your existing app and coding style), you could replace the local views in your DBC with another DBC with remote views of the same name and structure and your app would probably not even notice that your switched to SQL Server.

HTH