MySQL Forums :: Workbench - Schema Compare, Diff, Synch :: compare schemas on the same database instance
Re: compare schemas on the same database instance
Posted by: Chris Crossley ()
Date: December 02, 2009 05:06AM
My database server contains Dev, Test and Live. I reverse engineered the development database, added FK's a few tables and columns and pointed a sync to the live database. This generated a script that dropped all the live tables and created then again. I obviously didn't run the script. I tend to use diff scripts as a basis for a database patch. The only difference i can see on the objects is the schema owner. So i need to be able to switch this off while the diif runs.
It's not unusual to have more then one environment on a database server. This keeps the cost of running a service low.
It's not unusual to have more then one environment on a database server. This keeps the cost of running a service low.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| compare schemas on the same database instance | 6127 | Chris Crossley | 11/27/2009 11:08AM |
| Re: compare schemas on the same database instance | 2971 | Mike Lischke | 11/30/2009 01:10AM |
| Re: compare schemas on the same database instance | 2609 | Mike Lischke | 11/30/2009 02:32AM |
| Re: compare schemas on the same database instance | 2669 | Chris Crossley | 12/02/2009 05:06AM |
| Re: compare schemas on the same database instance | 2174 | Itamar Sion | 02/24/2010 04:48AM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates