15 Nov
2013
15 Nov
'13
8:23 a.m.
My first thought would be installing MySQL, though I believe PostgrelSQL is supposedly the
better choice at the moment. Obviously if you already have a SQL Server implementation,
that would be the easiest path to follow, though I believe SQL Server Express has the same
file size limitations as Access. Somebody please correct me if I am mistaken.
John-Paul Hopman
> I downloaded the Maryland state raw data (the
whole enchilada) that
> Penelope was good enough to provide me. It came with documentation that
> clearly explains what needs to be done but I am being hampered by the
> sheer sizeof the dataset. It's 10 GB and that's without going into
> joining tables, transposing them to meet my needs, etc. Even breaking the
> parts into different databases it can't be handled in Access. I can fit
> Part 1 into an ESRI geodatabase but I don't have the flexibility in
> linking tables that Access has.
>
> Does anyone have any suggestions for dealing with large databases? SQL
> server is one option. Are there others?
>
> Mara Kaminowitz, GISP
> GIS Coordinator
> .........................................................................
> Baltimore Metropolitan Council
> Offices @ McHenry Row
> 1500 Whetstone Way
> Suite 300
> Baltimore, MD 21230
> 410-732-0500 ext. 1030
> mkaminowitz(a)baltometro.org
> www.baltometro.org
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news