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
Enterprise-grade ITSM, for every business Icon
Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity.

Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Try it 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