>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

A mixture of Cursor Adapters and SQLPassthru is the way to go. CA's for most tables especially the updatable ones and SQLPassthru for lookups or adhoc ones.

Head down to www.foxite.com for some articles on CA's and dont forget the CA Builder from www.mctweedle.com. That's essential.

Since you will be using MSDE I am assuming that either the user base will very small (<10 simultaneous users) or this will be single user app. Don't forget that once you have 8 to 10 connections open in MSDE the Speed Governor kicks in and will slow you down to a crawl.

Once you go past MSDE to a full blown SQL system you will find that there are no longer speed restrictions but restrictions on your pocket with the extra grunt of a new server cost, User License fees per user/processor etc. Hope your wallet is bottomless or at least huge and stuffed with cash.

Good luck.