- Access - Oracle - Database -

[keetsh]

Hi there..

I'm currently programming a software which connects to an Access database thru SQL statements. Every database request, update, delete is in SQL. The only problem I now encounter is the database size...
Though I'm not using any Microsoft specialities in my code, I was wondering if I could replace my current Access database with an Oracle or whatever bigger database. According I have the drivers.

Could anybody help? Would be nice.

Thanks.

in theory replacing the database for a given application in VB chould not cause too many problems, at least when you designed your programm with care. Oracle is an excelent database, but i think it is easier to upgrade from Access to SQL Server then to Oracle (plus there is an assistent for that).

best regards

[keetsh]

Really? Depending on the language you're using or not? What are the advantages between an Oracle, SQL or at last an Access database?

How do you make an SQL database?

the programming language does not matter too much, since you connect to the database via a driver and use SQL statements (although there are a few differences between SQL dialects) to manipulate data.

Access is a nice desktop database, but running Access on a network, with a few concurrent users, will raise performance problems sooner or later. On the other hand, you don't need a database administrator when, which is required with the bigger DBMS. regular backups and frequent compressing should do. i mainly use Access for prototyping in the first phase of development and then upgrade the DBMS.

VB is Microsoft's client-server product and runs all together smoothly. the user interface of SQL Server 7 is nearly as good as Access's. the product is scalable, provides a decent performance, but you are limited to MS platforms.

i don't have too much experience with Oracle, but it has basicly the same advantages as SQL Server. When coming from Access, it probably takes longer to become productive with Oracle then with SQL Server. i also heard there are a few driver problems with Oracle too. if you plan to run your databases on non MS platforms (Unix, Linux ...), you should choose Oracle over Sql Server.

Hope that helps