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

You Might Also Like
Our Free Plans just got better! | Auth0 by Okta Icon
Our Free Plans just got better! | Auth0 by Okta

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your secuirty. Auth0 now, thank yourself later.
Try free now
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