Hi!
Try the upsizing wizard.
You can also use GenDBC.PRG to create the PRG for re-creating your DBC with all views. Then strip out from generated PRG the code part that re-create views. These are CREATE SQL VIEW commands and DBSETPROP() function calls. Only changes you need to do are change CREATE SQL VIEW command by adding "REMOTE CONNECTION {connection name}" clause to it, and fix any SQL statements for views to run them properly at the required backend (if backend is another than VFP database).
HTH.
>Is there a tool available that will automatically convert local views to remote views?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.