Re: Migration Project: MSSQL to Oracle

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: Nik Tek <niktek2005@xxxxxxxxx>
  • Date: Mon, 12 May 2014 16:15:07 -0600

Nik,
Sure, why not? It has to come across the network sometime, right? What's wrong with database links for straight loading?
I've done pre-datapump export->import pipelined to load 300-500 Gb databases in less than 10 hours (including index builds). The current NETWORK_LINK option in the datapump IMPDP executable using database links. 

Hope this helps?

-Tim


On 5/11/2014 10:19 PM, Nik Tek wrote:

Hi Tim,

Would dblink work for source database of size 100-300 Gb?

Regards
Nik
On Sun, May 11, 2014 at 4:30 PM, Tim Gorman <tim@xxxxxxxxx <mailto:tim@xxxxxxxxx>> wrote: 

    Oracle Gateway for SQL Server is a standard part of Oracle
    Database, downloaded as one of the seven download files.
    Installation and deployment is quite easy, and I don't believe
    there is any additional license cost;  of course you'll want to
    check that to be certain.

    The gateway allows you to query tables in SQL Server over Oracle
    database links.





    On 5/11/2014 4:59 PM, Nik Tek wrote:

    Hi Bobby,

    I'm not familiar with Oracle GoldenGate, and I'm not sure it is
    free to use it.

    The requirement is tool should be completely free.

    Thank you
    Raju


    On Sun, May 11, 2014 at 1:35 PM, Bobby Curtis - ACE
    <curtisbl@xxxxxxxxx <mailto:curtisbl@xxxxxxxxx>> wrote:

        Are you looking to write a tool to do the migration?  Are you
        prohibited from using Oracle GoldenGate?  There are tools
        that are designed to this already, please explain in more
        detail why you want to write a new tool.

        Thanks

        Bobby

        *From:*oracle-l-bounce@xxxxxxxxxxxxx
        <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
        [mailto:oracle-l-bounce@xxxxxxxxxxxxx
        <mailto:oracle-l-bounce@xxxxxxxxxxxxx>] *On Behalf Of *Nik Tek
        *Sent:* Sunday, May 11, 2014 4:16 PM
        *To:* ORACLE-L
        *Subject:* Migration Project: MSSQL to Oracle

        Hi,

        I have a question about migrating data from MSSQL and Oracle.

        I'm working on a migration project from MSSQL and Oracle.

        I have around 1040 tables on source (MSSQL) side, database
        size could be around 100-300 GB.

        I would have to do this operation repeatedly, so I'm thinking
        of creating it as a tool (command line based).

        Could anyone give me some guidelines on how to achieve it.

        * I have already created the destination schema on
        Oracle(Converted all SPs, Triggers, Tables, Views, Functions
        to pl/sql compatibility). I have to migrate data ONLY between
        source and destination databases.

        Source: MS SQL 2008 R2

        Destination: Oracle11g R2

        I have used Oracle's SQL Developer Migration Tool, but I'm
        not sure if I can bundle it as part of my software, as this
        tool is going to be free to the community.

        Thank you

        NikTekki

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2014