Professional Web Applications Themes

Convert data from MySQL DB to HSQL DB - MySQL

I have a question, and was wondering if someone could please provide some advise? I have a Db in MySQL and need to convert the data over to HSQL Db? What would be the process to do such an operation? Is there any open source (or may be a commercial) software that I can buy to perform this operation? Should the data be exported in XML format, and then conver it to the target XML, and somehow load the target XML into the target HSQL Db? Just a thought? Thanks for your time in advance?...

  1. #1

    Default Convert data from MySQL DB to HSQL DB

    I have a question, and was wondering if someone could please provide
    some advise?

    I have a Db in MySQL and need to convert the data over to HSQL Db? What
    would be the process to do such an operation? Is there any open source
    (or may be a commercial) software that I can buy to perform this
    operation?

    Should the data be exported in XML format, and then conver it to the
    target XML, and somehow load the target XML into the target HSQL Db?
    Just a thought?

    Thanks for your time in advance?

    javadev Guest

  2. #2

    Default Re: Convert data from MySQL DB to HSQL DB

    javadev wrote: 

    Seems to me that this would fit your needs...

    http://www.hsqldb.org/doc/guide/apg.html
    Walter Guest

  3. #3

    Default Re: Convert data from MySQL DB to HSQL DB

    Dear Walter

    Thanks a bunch for your note. I will try using the Transfer Manager
    from HSQL.

    thanks

    Walter Vaughan wrote: 
    >
    > Seems to me that this would fit your needs...
    >
    > http://www.hsqldb.org/doc/guide/apg.html[/ref]

    javadev Guest

  4. #4

    Default Re: Convert data from MySQL DB to HSQL DB


    javadev wrote: 

    Why not just use SQL from mysqldump?
     

    toby Guest

  5. #5

    Default Re: Convert data from MySQL DB to HSQL DB

    Toby

    Thanks for the note. I can try this one as well.

    I appreciate it.

    toby wrote: 
    >
    > Why not just use SQL from mysqldump?
    > [/ref]

    javadev Guest

Similar Threads

  1. code for mysql to pdf convert
    By aafreen281989@yahoo.com in forum Brainstorming Area
    Replies: 0
    Last Post: April 11th, 06:22 PM
  2. How do I convert data into a subscript?
    By cosmonot in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 7th, 10:18 PM
  3. Do you wish to convert data message on exit!
    By -[RiP]- in forum Macromedia Freehand
    Replies: 0
    Last Post: August 25th, 03:39 AM
  4. (ANN) FMP_MYSQL Tool - Convert your Filemaker db to MySql
    By Le Nomade.Com in forum FileMaker
    Replies: 0
    Last Post: July 31st, 01:59 AM
  5. [PHP] convert mysql datetime to unix timestamp
    By Adam Voigt in forum PHP Programming
    Replies: 1
    Last Post: July 28th, 04:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139