Typical database size increase after moving across to SQL

JamieBrown

Hi guys,

We’re contemplating converting our native db (3.7 running on 4.03 exe’s) to SQL and was wondering if / how much the size of the database will increase?

Our database is currently 190GB (150GB used).

I’m guessing there’s a whole host of factors that would affect the size (no. of keys, optimisation level etc…) but if there’s a general rule to follow or if anyone has any experience with this I’d appreciate any info.

Thanks

ara3n

on average sql db is about twice as big as native.

DenSter

That's before tuning indexes. Database sizes can be reduced dramatically by tuning indexes.