RE: Looking for a db schema read/write/synch tool

Posted in 2004

Balmer, Glyn — Fri, 14 May 2004 06:31:41 +0100 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C43974.BCB40340 Content-Type: text/plain PLEASE READ THE IMPORTANT NOTICE BELOW. DO NOT OPEN ANY ATTACHMENT WITHOUT PRIOR VIRUS CHECKING. __________________________________________________________________ Check out www.embarcadero.co.uk for ER/Studio as well Regards Glyn Balmer -----Original Message----- From: Daniel Morgan [mailto:damorgan@x.washington.edu] Sent: 14 May 2004 04:05 To: informix-list@iiug.org Subject: Re: Looking for a db schema read/write/synch tool 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) __________________________________________________________________ Liberata plc, 17 London End, Beaconsfield Old Town, Bucks HP9 2HN. IMPORTANT NOTICE: This e-mail (including all attachments) is confidential and may be privileged. It is for the exclusive use of the intended recipient(s) only, and must not be re-transmitted in an amended form without our consent. If you have received it in error, please contact us immediately at ITSecurity@liberata.com. Please then delete it and do not disclose its contents to any other person. Security and reliability of e-mails are not guaranteed. We operate anti-virus programmes but you must take full responsibility for virus checking this e-mail (including all attachments). Liberata plc do not accept any liability in respect of any damage caused by any virus which is not detected. All e-mails to and from anyone @liberata.com may be examined for breaches of employee policies and the law. All e-mails to anyone @liberata.com are communications to the company and not private and confidential to any named individual. ------_=_NextPart_001_01C43974.BCB40340 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2653.12"> <TITLE>RE: Looking for a db schema read/write/synch tool</TITLE> </HEAD> <BODY><CODE>PLEASE READ THE IMPORTANT NOTICE BELOW. DO NOT O= PEN ANY ATTACHMENT WITHOUT PRIOR VIRUS CHECKING. __________________________________________________________________ </CODE> Check out www.embarcadero.co.uk for ER/Studio as well</FO= NT> Regards Glyn Balmer -----Original Message----- From: Daniel Morgan [<A HREF=3D"mailto:damorgan@x.washin= gton.edu">mailto:damorgan@x.washington.edu</A>] Sent: 14 May 2004 04:05 To: informix-list@iiug.org Subject: Re: Looking for a db schema read/write/synch to= ol 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 task= ed at my job with > finding a tool that will perform the following task= s: 1) extract > schemas from a db, 2) produce a difference report b= etween 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 vendor= s (versions given > in parenthesis): Oracle (8i/9i), Sybase (12.x), Inf= ormix (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, DbVisual= izer, DBExplorer, > DBDiff, and AdeptSQL. I thought it would be a good = idea to post a > message to a few database newsgroups and ask for an= y 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.</FO= NT> -- Daniel Morgan <A HREF=3D"http://www.outreach.washington.edu/ext/certif= icates/oad/oad_crs.asp" TARGET=3D"_blank">http://www.outreach.washington.ed= u/ext/certificates/oad/oad_crs.asp</A> <A HREF=3D"http://www.outreach.washington.edu/ext/certif= icates/aoa/aoa_crs.asp" TARGET=3D"_blank">http://www.outreach.washington.ed= u/ext/certificates/aoa/aoa_crs.asp</A> damorgan@x.washington.edu (replace 'x' with a 'u' to reply) <CODE> __________________________________________________________________ @@