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
MongoDB Atlas runs apps anywhere Icon
MongoDB Atlas runs apps anywhere

Deploy in 115+ regions with the modern database for every enterprise.

MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
Start 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