Book a Demo

Author Topic: Table space size?  (Read 2455 times)

mcintoshi

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Table space size?
« on: April 01, 2008, 05:47:05 pm »
Is there any way in Enterprise Architect to export or obtain the table size (in bytes) from a database schema diagram?

I'm creating a new schema and I need to give the DBAs an idea of the required table space.  I know roughly the expected data volumes for each table, but I need to multiply these by the space needed for each row, and I'd rather not have to go through the painstaking task of adding up the bytes for each field in each row in each table.

cheers,
Ian

mcintoshi

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: Table space size?
« Reply #1 on: April 02, 2008, 12:21:12 pm »
Anybody know if this is possible within the current feature set?

(Alternatively if there's an easier way to do this outside of EA that I've overlooked, I'm happy to be pointed in that direction too...)   :)

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Table space size?
« Reply #2 on: April 02, 2008, 04:22:50 pm »
I guess it would be easy enough to write a small tool to export your table definitions to an Excel file; which can then do the calculations for you. You don't even need to write an addin for that. Just mess about with VBA in Excel to extract the data from EA.
Should take not more then about two hours to get it working correctly.