We help IT Professionals succeed at work.

Migrating from MSAccess

elise_r
elise_r asked
on
Medium Priority
239 Views
Last Modified: 2010-04-05
I have spent lot of time working with DB using Access  driver, but now our requirements have overgrown capabilities of Access, especially in multi-user tasks. I need to switch to something else that works better than Access, uses no BDE/ADO/DAO/ODBC connection, handles multi-user fine and supports full-featured SQL.
Comment
Watch Question

Commented:
Definitively Oracle – it’s the most powerful.

Commented:
I know Oracle is not bad :) but it costs a whole bag of bucks. I need something less expensive, without royalty fee.

Commented:
When I was walking myself through this choice I picked up Absolute Database from www.componentace.com; after free evaluation I understood that it can fully replace any other DB. Plus it has many extended useful features such as encryption and memory usage. It is especially good in handling frequently-queried tables.
Moreover they have a good support team that answers a question within half a day. When I meet a difficult place I ask ‘em and they write a demo for me which is actually code I need. Just don’t use it very often ;)
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
You might wanna check out firebird http://firebird.sourceforge.net/ its an open source verson of Interbase.
Yea, FireBird is a good choice if you want opensource but with support for SP and Triggers (which mySQL doesn't have, yet)

Also check out the Embedded Firebird, which allows you to deploy your app without installing the whole Firebird DBMS package.

Commented:
DS:
The whole FB package.... 3.5 Mb... ;-))))

 elise_r :

You can access directly Firebird with:
Commercial ones:
--> IBO -- one of oldest and coolest component suite to Interbase/Firebird (www.ibobjects.com)
--> FIBPlus -- a newer suite, earned respect from community (http://www.devrace.com/en/fibplus/?r1=fibplus&r2=Direct_Link)

Free/Open Source
UIB -- a suite of components for Firebird/Interbase (http://www.progdigy.com/UIB/). They have also
 DBExpress drivers
Mercury Database Objects(MDO) -- brazilian opensource suite for Firebird/Interbase
 http://mdo.sourceforge.net/
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.