Tuesday, March 27, 2012

Database Sizing

I need to convert a hierarchical database and a Siebel
Relational database to SQL a Relational database. I
currently have two databases list below:
29,151,892 MB = hierarchical database
8,222,178 MB = Siebel Relational database
About what size of a database would this be in SQL?
Hi,
Storage depends up on the way you are going to redesign when you move it to
SQL Server. If it is going to be Siebel to SQL Server direct
loading then the storage will be almost identical, but whn you create
indexes the storawill go high. So I recommend you to have atleast double the
size of
current database projecting the data growth as well.
For the Hierarchical database you might require a new relationa redesin.
This will re-use the storage and may not require more space. So probably you
can have 1.5 times of current size to hold the indexes and new data.
All these are just assumptions. To get it almost correct value you have to
do some small calculations based on the books online topic "Estimating the
Size of a Table".
Thanks
Hari
MCDBA
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:2a07601c46542$92b74df0$a301280a@.phx.gbl...
> I need to convert a hierarchical database and a Siebel
> Relational database to SQL a Relational database. I
> currently have two databases list below:
> 29,151,892 MB = hierarchical database
> 8,222,178 MB = Siebel Relational database
> About what size of a database would this be in SQL?
>

No comments:

Post a Comment