Data migration

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • venkattaramanan
    New Member
    • Feb 2008
    • 1

    Data migration

    Hello,

    Actually i want know how to migrate the oracle datas into Mysql datas using visual basic program


    regards,
    V.Venkattaraman an
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Originally posted by venkattaramanan
    Actually i want know how to migrate the oracle datas into Mysql datas using visual basic program
    Could you be a bit more specific about exactly what you want to do, what you've tried, and what sort of problem you're having?

    I mean, if you are able to open a database connection to Oracle, and do the same with MySql, then I imagine you've basically got the job done.

    Oh, and one other thing - what version of VB are you using?

    Also, why do you need to use VB for the migration. I'm sure there are tons of data migration tools out there already, without coding it yourself. And the chances are good that either Oracle or MySQL can do it for you. Or you could just export from one, and import to the other.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      There is no direct method in Oracle ,Mysql or VB .

      You just need to use third party migration tools.

      Comment

      • Killer42
        Recognized Expert Expert
        • Oct 2006
        • 8429

        #4
        Originally posted by debasisdas
        There is no direct method in Oracle ,Mysql or VB.
        Depending on what's required in terms of conversion, couldn't you just export/import?

        Comment

        Working...