?
Solved

Choosing A DBMS System(little data , Complex forms)

Posted on 2003-03-29
1
Medium Priority
?
277 Views
Last Modified: 2012-08-13
Hello everyone,

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
zxdfgh
0
Comment
Question by:zxdfgh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
ornicar earned 200 total points
ID: 8232162
As far from what I understand with Oracle pricing, for a small number of users, the cost is similar to SQLServer, although SQLServer is presented as a better choice in a performance/price point of view for small/medium databases.
For a website, 1 license will be enough (=5 users), as far as I have caught.

<Is Visual basic the front-end development environment of choice for SQL Server?>
Not sure. When Access was released, the limitations were very big, specially with the network speeds at these times. So M$ announced they start the development of a DB server (SQLServer). Access, specially 2000 & XP are very good front-ends for SQLServer, with the advantage over VB that it generates forms specially for a database. With VB, there is much more work to do, or you may use a form library for databases. No, definitely, Access IS the choice for developing on SQLServer.

With Oracle, consider you will need a developer license as well, so I feel that using SQLServer with Access as frontend is your best bet, only adapting the existing application to make all queries run on the server. Or at least the hungryest ones.

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this article, we’ll look at how to deploy ProxySQL.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question