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
Categories
DatabaseLicense
GNU General Public License version 3.0 (GPLv3)Follow Synchronous structure of Database Script
User Reviews
-
Added Exlucde Tables List to export. It's only support one Primary Key, not Multi Pri or Uni Key