migrate oracle data to vertica using squirrel

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

Comments

  • SruthiASruthiA Vertica Employee Administrator

    Hi,

     

       Generally most of the people use either squirrel or DbVisualizer to migrate data to vertica. You can download them from 

     http://www.dbvis.com/

     

    http://squirrel-sql.sourceforge.net/

     

    -Regards,

     Sruthi

  • i try it with squirrel using copy paste bt it didnt work :(

  • SruthiASruthiA Vertica Employee Administrator

    What do you mean by copy paste?? Could you give more insight on it?? Please have a look at the following URL to connect to vertica using Squirrel

     

    https://tomgendron.wordpress.com/2011/08/26/connection-to-vertica-with-squirrel-sql-client/

     

    -Regards,

    Sruthi

  • I have another query would you please help me? recently i started work on vertica. 

  • SruthiASruthiA Vertica Employee Administrator

    Sure. Please let me know. if I can I will help you.

     

     

    -Regards,

     Sruthi

  • I installed vertica at one machine by using Virtual Box and Install centos on that. But now I want to install vertica on clusters i mean on three machines. so how to create three machines of centos for vertica. 

  • Follow this how-to to see how you can install a Vertica Database 3 node cluster 

    Vertica 3 node Cluster Install on CentOS.

     

    But you should also go thru the oficial documentation. 

  • yeah i already see this link. but this is about server installation. i want to knw abt otherz node. should i have to install Virtual box then centos and vertica as well over there. like we did at server.

  • SruthiASruthiA Vertica Employee Administrator

    Hi,

     

       Are you using Oracle VirtualBox? if so, did you create VM's on VirtualBox and then installed centOS on all VM's?

     

    -Regards,

     Sruthi

  • Ok , 

    Here is tutorial on how this can be done :

    Creating Vertica Sandbox Environment

     

    Norbert crated this nice tuts on how you can create a simple Vertica cluster enviroment.

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file