Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-31 : 08:22:41
|
| Herlinda writes "Hi,I have to migrate a 5.5GB Oracle database to SQL Server.Could you help me estimate the size of the database in SQL Server?I need to estimate the server size to have SQL Server with the same performance I have with Oracle, this is how many HD's will I need and what type, and the amount of RAM.This change is because Oracle wants a lot of money for the licenses and we cant afford them. So I need to calculate the impact of buying another server.We have an HP-UX with 4 HD of 18 GB.Thanks in advanceHerlinda Mancera" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-07-31 : 11:01:29
|
Estimating the size of the database is more of an art than a science!  Your best option is to bring in a SQL Server expert on board to help you with the transition. But if you want to do it all yourself... I would start by estimating the size of each table and then adding the results together. Here is an article which might help: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.aspEdited by - izaltsman on 07/31/2002 11:03:56 |
 |
|
|
|
|
|
Database size