locked
Oracle to SQL 2012 migrataion RRS feed

  • General discussion

  • Hi,

    I am planning to migrate Oracle 11g to SQL Server 2012. I want to estimate the Sizing requirement based upon actual usage. please let me know how I can get usage data from Oracle which I can use to size SQL Server Servers.

    Thanks

    Ashu

    Tuesday, March 11, 2014 11:38 AM

All replies

  • Hello,

    The following article will help you determine the actual size of databases on the Oracle side to later estimate storage needs on the SQL Server side:

    http://nimishgarg.blogspot.com/2010/05/oracle-total-size-of-database.html

    To hardware sizing SQL Server, the following link may help:

    http://www.sqlcoffee.com/Tips0012.htm

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Tuesday, March 11, 2014 1:44 PM
  • Hi,

    I am actually looking for template than guidelines.  For migration from Oracle to SQL, I need to size the new hardware which should take equal load. What all parameters I can consider for Oracle in RAC which can be used to arrive at Cores and RAM requirement.

    Thanks

    Ashwani

    Thursday, May 8, 2014 8:33 AM
  • Hi,

    I am actually looking for template than guidelines.  For migration from Oracle to SQL, I need to size the new hardware which should take equal load. What all parameters I can consider for Oracle in RAC which can be used to arrive at Cores and RAM requirement.

    Thanks

    Ashwani

    Sizing a hardware would actually require you to first migrate Oracle to SQL server and then do a load test to check its capability. If you are asking about space used that would be almost equal ,if you are asking about database growth then again you need to analyze database and its traces to find how much actually database is growing. In my case space required was almost same for the databases.

    Did you tried SSMS ( SQL server migration assistance )

    http://technet.microsoft.com/en-us/library/hh313179.aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    My TechNet Wiki Articles

    Thursday, May 8, 2014 3:03 PM
  • Hi Shanky,

    SSMA tool doesnot provide RAM and Cores recommendations.

    Thanks

    AShwani

    Tuesday, May 13, 2014 10:03 AM
  • SSMA tool doesnot provide RAM and Cores recommendations.

    That is what I said how could you accurately predict RAM and disk requirement without actually running system for couple of weeks with load on it.I gave SSMA for migration assistance.

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    My TechNet Wiki Articles

    Tuesday, May 13, 2014 10:34 AM