locked
Oracle 8.1.5 to Azure SQL Server RRS feed

  • Question

  • Hi, 

    I am in a process of looking out at options to move client's old database, built in Oracle 8.1.5 to our new Azure SQL Server environment.

    I was initially looking at SSIS and Data Factory but somewhere read about SSMA. I looked at the details and this is what I found:

    

    I looked at older version, V6.0 and that too has the same requirement of V 9.0 and later. 

    If this is the case what are my options, considering there are 80+ tables and it would be difficult to design and Dev as many SSIS packages.

    Thanks in advance for your help.


    Cheers!! Sumit Bhatnagar

    Monday, May 22, 2017 4:55 AM

Answers

  • Hello,

    That refers to the Oracle Client, not to Oracle Server Version. You can use Client 9.0 to connect to a older Oracle Server, like Version 8.1.5.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, May 22, 2017 5:49 AM

All replies

  • Hello,

    That refers to the Oracle Client, not to Oracle Server Version. You can use Client 9.0 to connect to a older Oracle Server, like Version 8.1.5.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, May 22, 2017 5:49 AM
  • Thanks for confirming this.

    Cheers!! Sumit Bhatnagar

    Monday, May 22, 2017 5:56 AM