InterBase database migration to MySQL (description)

Source: Internet
Author: User
Tags interbase

Just to the company 1 weeks then received the first demand, into a few days of communication understand is from the GBK file to recover the InterBase database, and then restore to the database data exported to the remote MySQL database, get the need to step to see the problem, the problem can be broadly divided into three steps, Each step of a script file is divided into three Python files to execute.

The first script implements a command to restore the ". GBK" Database backup file to ". GDB "format database file with the following command:

Python restorewin.py-gbk backup file-gdb recovered database

The second script implementation exports the data from the InterBase database to a text file (. txt) that can be recognized by MySQL, with the following command:

Python output.py-i configuration file-O export file

The third script implementation imports the exported text file into the remote MySQL database via the SQLAlchemy framework on Python, with the following command:

Python inputdb.py-f files to import

For my later convenience memories, I will be divided into three separate narrative three files of the content and attention to issues and problems encountered.

InterBase database migration to MySQL (description)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.