SQL Version Control Tools

We're now in the unlucky position of having to support not one but two different database engines. Although we've designed the software as much as possible to be standard, we've still been bitten - recent messages in the conference on TEMP tables show that :)

Can anyone recommend a good tool to replace the ISQL/W ISQL-Worksheet type tools with something that does some of the following :

 o Works with a source code control system to control versioning and to    stop two programmers working on the same table at once.  o Convert SQL from one dialect from another (!!) if such a thing exists    We've manually had to go through and re-code SQLS6.5 SELECT statements    for Oracle and it's been a real PITA! :)  o Reverse engineer DDL statements from one engine to another (Oracle and    SQLS6.5 at present but maybe others later..)  o It would be *amazing* if the package could take two versions of a    schema and generate the DDL statements to bring the older one in    line with the newer - we do this by hand at the moment and it's    impossible with 6-monthly/yearly releases to keep track of it all..    

So far we've looked at the following :

 o PowerSoft PowerDesigner
 o Embarcadero RapidSQL (the other tools look cool too but their    site is currently down as far as downloading is concerned...)  o ER/Studio (from the guys that do RapidSQL)

Can anyone suggest alternatives or have you any experience of using any of these? We feel that we really need a tool to help out with this stuff....!

Thanks for reading,

//chris Received on Fri Jan 15 1999 - 11:53:50 CST