Database for Archiving

**inspiroHost** · Apr 15th, 2011, 10:56 pm

I'm just starting to set-up my Museum-Archives and was wondering what kind of database to be used? MS Access is okay but I don't know hot to set it up and if somebody can help me?

**waynewex** · Jun 27th, 2011, 10:06 am

MySQL? Oracle?

MS Access isn't really a great solution.

**minfo** · Aug 6th, 2011, 12:06 am

Move less frequently accessed data out of your production database and improve the slow performance with the Informatica Database Archiving solution.

**Rukbat** · Aug 26th, 2011, 2:48 pm

You can use Access. Just learn how to design a database (you'll have to do that no matter which database you use) and it should work unless you have enormous amounts of data. We use it in production all the time for small needs. (Not because we have nothing better - the Oracle RDB on the VAX could handle a few Fortune 500 companies in addition to what it does now without noticing it.)

**jaydeee** · Sep 9th, 2011, 5:44 am

Access DB may be good but I know there is a file size limitation. Depending on the amount of data you'll be storing I would suggest MySQL, MSSQL and Oracle.