Solved

MySql: difference between 2 databases

Posted on 2013-01-15
4
356 Views
Last Modified: 2013-01-23
Hello,

We constantly develop our development database which need to be synchronized from time to time with the databases of different customers.

I need queries for the followings:

- the table names found in database "A"  but not existing in database "B"

- the table names.field names found in database "A"  but not existing in database "B"

(in other words the new field names which exist in "A", but not in "B")

- the stored procedure names found in database "A"  but not existing in database "B"

Thank you
0
Comment
Question by:starhu
  • 3
4 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38778485
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38778488
0
 

Author Comment

by:starhu
ID: 38792404
Thank you for the answers.

The problem is that I have many customers and it would be very time consuming to install a software on each computer.

Isn't there a portable version, or just some Mysql code which puts the differences is a table?

Thank you
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38792411
not really. though you can check the table listing (SHOW TABLES http://dev.mysql.com/doc/refman/5.0/en/show-tables.html), it will require some coding to implement the "updating" into the application.
but it looks like what you need to do ...
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL Init Waits 25 116
showing numeric numbers 2 38
Easy to use inventory management software 7 107
A query works with MySQL 5.6, mariadb 10.1 but fail on MySQL 5.7 6 47
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question