Skip to main content

How to Migrate Oracle tables to Vertica DB

  • August 16, 2013
  • 4 replies
  • 19 views
Siva_Ram
How to Migrate Oracle tables to Vertica DB

    4 replies

    Prasanta_Pal
    Forum|alt.badge.img
    • Prasanta_Pal
    • Participating Frequently
    • August 17, 2013
    There are posts on this, you may check http://community.vertica.com/vertica/topics/how_to_migrate_oracle_tables_to_vertica_db
    Prasanta_Pal
    Forum|alt.badge.img
    • Prasanta_Pal
    • Participating Frequently
    • August 17, 2013
    Anotherway, in vertica create a external Stored Procedure ( which is nothing but a .sh ( shell scripts)). This shell script can connect to Oracle and pull the records and use COPY command in the script to load to Vertica.
    abira
    • abira
    • Participating Frequently
    • May 7, 2015

    is there any way to migrate oracle data to vertica using squirrel or any other tool?? plz 

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • May 12, 2015

    Your question is very generic ! 

    I think you should choose one tool and ask how you can migrate using that tool ! ? 

    Give it a try first on your own then start asking ! 

    Eg : some etl tool(Pentaho,Talend,Syncsort DMExpress)

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement