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

    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.


  2. #2


    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.....

  3. #3
    Join Date
    May 2006


    There are better tools available to copy databases ;-)


  4. #4
    Join Date
    Jun 2007

    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.