In some cases, the two databases have a number of different tables, in different tables there are different columns, this code will help them blend together.
Follow these steps:

Step 1. Select the source database ->
-> Load Tables
-> Select Tables to exclude export
->Export current database -> .ini file.
Step 2. Select the database to merge, upload the ini file in step 1.

The code scans all tables of the source db and compares them to the target db
1. If the table in the source db does not exist in the destination db -> create the table in the destination db
2. If the table in the source db already exists in the destination db, it will browse all the columns in the source db's table. If the column in the source db does not exist in the target db's table, it will add this column for the table in the target db in the correct data type, default value, ... of the column in the source db table.

Features

  • Create new table on destination db if table not existing on destination db
  • Add new Column to table of destination db if this column not exist on table of destination db
  • Only import struct
  • Not lost any current data

Project Activity

See All Activity >

Categories

Database

License

GNU General Public License version 3.0 (GPLv3)

Follow Synchronous structure of Database Script

Synchronous structure of Database Script Web Site

Other Useful Business Software
Go From AI Idea to AI App Fast Icon
Go From AI Idea to AI App Fast

One platform to build, fine-tune, and deploy ML models. No MLOps team required.

Access Gemini 3 and 200+ models. Build chatbots, agents, or custom models with built-in monitoring and scaling.
Try Free
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
1
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5

User Reviews

  • Added Exlucde Tables List to export. It's only support one Primary Key, not Multi Pri or Uni Key
Read more reviews >

Additional Project Details

Programming Language

PHP

Database Environment

MySQL

Related Categories

PHP Database Software

Registered

2020-07-05