15 Nov
2013
15 Nov
'13
8:41 a.m.
I think SQL Server express is 10GB and Access is 2GB. So SQL would work
for me if I broke the databases up into Parts 1-3, which I was going to do
anyway.
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of John-Paul Hopman
Sent: Friday, November 15, 2013 9:24 AM
To: CTPP News
Subject: Re: [CTPP] Adventures in large datasets
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
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news