Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Comparing databases - what is the best way?

by jplindstrom (Monsignor)
on Apr 13, 2006 at 13:34 UTC ( [id://543079]=note: print w/replies, xml ) Need Help??


in reply to Comparing databases - what is the best way?

If what you want to do is to compare the table structure, SQL::Translator may work for you. Pretty impressive project. It has a sqlt-diff tool which can be used to create alter scripts between schemas.

I researched this the other day, looking for a tool to help upgrading schemas, and my impression is that the capabilities seems a bit spotty, and the database support is somewhat uneven. If you use MySQL it may work just fine, if you use Oracle (like I do in the current project) or some other database, it may depend on what features you use in the schema. For example, the Oracle diff seemed to lack support for sequences and partitions, just to name a few things.

(One other tool I looked at briefly is Embarcadero Change Manager, which looked very competent and feature-complete. It operates on db connections though, not SQL DDL statements which I would prefer.)

/J

  • Comment on Re: Comparing databases - what is the best way?

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://543079]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (2)
As of 2024-04-26 05:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found