What is most difficult is how you'll move your application from point A (F/S) to point B (C/S), what path you'll follow.

As you don't seem to have a prior C/S server experience, I would recommend this path:
1- replace xBase data commands by SQL commands in cursorAdapters
2- using SQL server upsizing wizard, write a program to nightly upsize your VFP data to your SQL DB
3- switch the VFP cursorAdapters to SQL server, eg by adding a property to address either one.

This way you and your users will be able to test your application against both data source and make sure app behaves the same.

>Hi,
>
>I have an app with 45+ users on a File Server network. It has been working well for several years and I have a lot of functionality built into it. The problem is it was conceived many years ago and is table based with no views. The client is considering using MS SQL Server due to the need for security. I realize that my DB design is antiquated so I am considering a re-write of the app. I have no experience with C/S and little with SQL Server so I am trying to learn both. My question is what would be the best course for re-writing the app; (using a Promatrix Framework)
>
>1- Build local views then remote views?
>2- Views or CursorAdapters?
>3- What major issues must I consider in my code?
>4- Which version of SQL Server 2012 can I download for development/testing that is free?
>
>Any help suggesting the best path for me to conquer this task would be appreciated. I know it will take time but some guidance will help.
>
>Thanks in advance,
>
>Bill