March 7, 2013 at 11:51 am
Hi we are migrating Oracle database to SQL Server the database size in Oracle is 5 TB. what wil be the size of this Oracle database in SQL Server once it is migrated. There might be the concerns abt what datatypes i am using, indexes and all. Counting all this concerns in general can i have a rough estimate..
Thanks a ton in advance! 🙂
March 7, 2013 at 1:08 pm
It depends on what data types you're using in Oracle versus what you're going to use in SQL Server. Each platform stores things a little differently, so the usual "it depends" comes up.
If I were doing this, I would start by creating a SQL Server database in a test environment with an initial size about the same as the Oracle database. Then do the migration (knowing in advance that you may very well have growth) and check your size in SQL Server. See what is actually used in SQL Server when you're done and increase it by about 5% to allow for some more data before it needs to grow.
This is based on knowledge of Oracle 8, so it may be different than your (probably more current) version of Oracle.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply