>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.
I second Bill's opinion about MSSQL vs MySQL.
I use both.
SQL Server is powerful - the query optimizer is just amazing - it is very fast on queries that make MySQL Stumble.
I don't know how to evaluate the cost - you can get more info from others here.
I will say that MySQL looks cheaper, but getting some queries to perform well requires a lot more hours, as well as some inspired creativity.
The thing I like about cursor adapters is that they can be built into the data environment and are part of the form.
Remote views are external to the form.
Do some research and read some books and then make some throw-away forms for practice before changing your real project.
Good Luck!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only