Thanks ED, I have arise with some doubts based on your answer:
I have only connect to other backends with odbc Remote views ans sqlPT where can I see more about oledb and ADO access? What is the difference ?

Upsizing is not a concern, since will be for new development, just read current progress tables and connect to other db maybe sqlserver, or keep the data in progress and work with vfp, what do you think about this, AFAIK from VFP tp any backend DB you can only work with RV's and SQLPT ?


Thanks again

By the way what is CA?



>>Hi all, I need to aquire a new development tool for a big local company, and
>>as my knowledge for enterprise development I will like to to use VPME/VFP but
>>have the following concerns:
>>
>>1. will it work with Progress RDMS (the company has all its prior data in
>>progress in a unix server) Has some one have experience with this database?,
>>it does not provide a odbc, there are some other odbc providers but dont
>>know exactly its performance.
>>
>
>There are ODBC and OLEDB drivers available for Progress, so that you can use RVs/SPT and ADO to access Progress files. there's no direct upsizing wizard for it like there is for SQL Server and Oracle AFAIK. With VFP8 and the CA, the backend issue becomes trivial.
>
>>3. we will like to start moving to another db, what will you suggest
>>(SQLserver, .....) What is the best approach to connect to sqlserver is
>>there a direct connection, since saw a program made in vfp that uses mssql
>>but says has vbasic in the middle for connection.
>>
>
>There is a direct upsizing wizard for SQL Server that builds RVs; you can port SPs from the Progress environment by hand to SQL Server by translating them to T-SQL. Again, with the CA, once you figure out how to get the data into the backend, accessing it becomes easy with VFP8.