Hello,

I have the task to move VFP application from native DBC database to MSSQL Server (MSDE).

I have experience working with SQL Server using SQLCONNECT/SQLEXEC/etc functions and submitting SQL commands to SQL server. I have read that there is another approach to manage data in sQL server - remove views. I think that using remote views would be more convenient (than using SQLCONNECT) way to move my application from DBC to MSSQL Server.
Am I right?

What are advices, suggestions, warnings when moving from VFP's DBC to MSSQL+remote views? Is there any sources to read in internet?

Thanks