Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Choosing A DBMS System(little data , Complex forms)

Posted on 2003-03-29
1
Medium Priority
?
289 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
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this article, we’ll look at how to deploy ProxySQL.
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…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

580 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