Storing large amounts of data
Posted on 2004-09-28
I need an expert's advice on where to store large amounts of data. Currently, we have multiple Access databases that I am looking into consolidating in one place.
I was thinking about SQL server...I work for a big company and my department doesn't have a SQL server. There might be a possiblility of buying a SQL server or, may be, just disk space on the existing server from another department. Do I have any other options besides SQL server? I know that there is an Oracle server as well, that another department owns.
Is there are a database, bigger than Access, but cheaper than SQL/Oracle server? We have weekly and monthly tables of data that we would like to store in one place and reference it (pull selected data) when needed. The size of the data would not exceed 20G.
Thank you for your help.