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