locked
Migration of Data from Oracle DB to SQL DB using webservices RRS feed

  • Question

  • Hi ,

    I am using SQL SERVER 2008 R2. My clients requirement is to Migrate the data from Oracle 11g Database to SQL Database ONLY using WEBSERVICES. In addition, from the migrated data i need to create SSRS reports .Please suggest me how can i acheive this.

    Any help is highly appreciated!!


    Thanks in advance, Akhila Vasishta

    Saturday, December 22, 2012 10:17 AM

Answers

  • Hi,

    I don't know if the migration will be once or it should be executed periodically, any way You have multiple options to implement this:

    1- Developing a .Net Web service from scratch doing the extracting from Oracle and Loading to SQL DB using ADO.Net components.

    2- Developing SSIS package to do the extraction from Oracle and then loading the data to SQL server DB then interfacing SSIS package with a web service which launch the execution of those packages (which is much easier then the first option), you can use OLE DB driver for Oracle to connect to Oracle DB.

    3- If your requirements is just to have reports you can do it directly using SSRS using your Oracle DB as Data source.

    4- If you have to do the migration once, you can use also Microsoft SQL Server Migration Assistant for Oracle.

    http://msdn.microsoft.com/en-us/library/hh313202.aspx


    MVP SQL & BI Specialist http://wissemhabboub.unblog.fr

    • Proposed as answer by Fanny Liu Monday, December 24, 2012 8:24 AM
    • Marked as answer by Fanny Liu Friday, December 28, 2012 3:04 AM
    Sunday, December 23, 2012 5:37 PM