Re: Difference in schema



EN wrote:
I'm looking for software which might give me difference
between schema two databases in Postgresql.
The main purpose is catch difference between production and development db.

It should be relatively easy to write a comparison tool yourself, using the DatabaseMetaData.getTables and DatabaseMetaData.getColumns methods to obtain detailed information about the structure of each schema.

David Harper
Cambridge, England
.



Relevant Pages

  • Re: Move sharepoint to another server
    ... test environment's schema that aren't in your production's schema. ... customization in your production environment. ... > sharepoint portal server 2003 in my test server, now i want to move all ... Please upgrade the database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: refreshing AD in testlab environment
    ... If you have two separate forests you can't magically bring across schema ... want to bring the testlab up to production leve. ... service accounts we use in production are different than the testlab. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Test Environment - How?
    ... I need the schema to come across (actually, if I could get the schema ... production, but I only want 2-3 in test, so I assume I don't want ... In addition to what Simon already suggested, you could try and test your Domain Controller backups by restoring the Active Directory Backups on the test environment machines. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Question on Active Directory Schema Expansion
    ... All of my experience in the last 10 years has been in Fortune 50 or bigger, primarily Fortune 5 all of which tend to have banking or trading divisions. ... Prior to doing an actual live production forest update of a schema I tend to recommend sucking off the live production domains onto DCs and stick them in a segregated room cut off from the rest of the network and apply the changes there and see how they impact the production schema. ... I recall the first schema update we did for one of the Fortune 5 companies that MS told us would be done in about 90 minutes because that is what it took in the lab they mocked up for it... ...
    (microsoft.public.win2000.active_directory)
  • db synchronization
    ... - compare 2 db schemas and update the production schema from the DEV schema. ... Only the schema, not the DATAS!! ... - you add a field within a table within your DEV environment -> it creates ...
    (comp.lang.php)