Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to copy entire database from source to target

  1. #1
    Join Date
    May 2007
    Posts
    4

    Default How to copy entire database from source to target

    hi guys
    i want to copy my entire database from MSSQL to my mysql server. i just want to keep all of my records in mysql . i dont want to lost table relation .(keep everything in Mysql ,as it is in MSSSQL)

    is it possilbe using Kettle??

    is there any to input a whole database. i see there is input table component by which u copy every table separately, but my point is different.

    plz reply me.

    regards
    jguru

  2. #2

    Default

    You can only migrate data using kettle. Initially, you have to make your DB tables ready in MySQL then you can transfer data from table by table (or a job to do for all tables).
    Check this link.....
    http://kettle.pentaho.org/tips/?tip=8

  3. #3
    Join Date
    May 2006
    Posts
    4,882

    Default

    There are better tools available to copy databases ;-)

    Regards,
    Sven

  4. #4
    Join Date
    Jun 2007
    Posts
    1

    Default MySQL Migration toolkit

    You can download the above-mentioned migration package from the official MySQL site. I have tested it with lots of different databases and it works!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.