Choosing A DBMS System(little data , Complex forms)
Posted on 2003-03-29
My question isn’t technical, I am having some system design issues.
I am going to migrate an Access system at a small company. The system does not have a lot of data but the forms are very complex and run multiple queries, which slows down the system.
My 2 migration options is SQL server & Oracle
Do you think migrating to Oracle just to use Forms and Reports is overkill? I have used it before and think it is very stable. In terms of cost is the Oracle web site realistic? A system with 5 clients is very expensive.
For SQL server we have small business server and it does have SQL server in it.
Would there be a need to purchase a stand alone version?
Is Visual basic the front-end development environment of choice for SQL Server?
In terms of cost both systems seem to be the same price, am I mistaken? If so I do not see why I should go with SQL Server. I would migrate my data to Oracle and use the Access forms, later on transfer the system to Oracle Forms&Reports.
Thanks in advance