Looking for a db schema read/write/synch tool
Hello, I'm relatively new to the database world so please forgive me in advance for my ignorance. I have recently been tasked at my job with finding a tool that will perform the following tasks: 1) extract schemas from a db, 2) produce a difference report between schemas from two databases, and 3) synchronize two schemas. The purpose is for product upgrades during which an existing database schema will need to be synchronized with a baseline schema. The tool must support the following database vendors (versions given in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS 2000, and IBM DB2 (7/8). I have spent the last several days downloading and researching a variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, DBDiff, and AdeptSQL. I thought it would be a good idea to post a message to a few database newsgroups and ask for any recommendations database developers may have. So if anyone has any recommendations on such a tool or software package, I would greatly appreciate any information. Thanks! Chad Smith
In article <75a71a26.0405131102.7ded4080@posting.google.com>, Chad Smith (itclguy@comcast.net) says... > I have spent the last several days downloading and researching a > variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, > DBDiff, and AdeptSQL. I thought it would be a good idea to post a > message to a few database newsgroups and ask for any recommendations > database developers may have. > Add Sybase Powerdesigner to the list. Ive done that with the DataArchitect version but it might also work with PhysicalArchitect. The last one is much cheaper.
Chad Smith wrote: > Hello, > > I'm relatively new to the database world so please forgive me in > advance for my ignorance. I have recently been tasked at my job with > finding a tool that will perform the following tasks: 1) extract > schemas from a db, 2) produce a difference report between schemas from > two databases, and 3) synchronize two schemas. The purpose is for > product upgrades during which an existing database schema will need to > be synchronized with a baseline schema. > > The tool must support the following database vendors (versions given > in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS > 2000, and IBM DB2 (7/8). > > I have spent the last several days downloading and researching a > variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, > DBDiff, and AdeptSQL. I thought it would be a good idea to post a > message to a few database newsgroups and ask for any recommendations > database developers may have. > > So if anyone has any recommendations on such a tool or software > package, I would greatly appreciate any information. > > Thanks! > Chad Smith Add Computer Associates All Fusion ERwin to the list. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)