>Hi Bill,
>
>>I need help in converting sql server database to vfp can any body help me with a quick idea to solve this issue
>
>Try:
>- For each table in SQL database;
>- Select the datas;
>- Copy to comand.

Actually, it can be automated a bit further, but I seem to have lost the code I wrote three years ago when I last did it.

Two more things:

First, start a new database, and Copy To it (i.e. copy to .... database {newdbc}). That should take care of long field and table names.

Second, check for impossible names. SQL server allows a few characters which VFP doesn't, like # (and maybe a few more I didn't have a chance to encounter). VFP will replace such characters with underscores, but you need to keep that in mind for later updates.