We have a Database on SQL Server and Mirror version of it on Oracle on a Web-server. When I make structural changes to the SQL Server DB via a Script of DDL, I would like to be able to take this script and convert it to Oracle DDL to apply to the Oracle DB.

We can do this manually of course but it would be preferable to be able to run the script through some automated tool to convert it to remove the Human Error aspect. It would also be less time consuming.

Does anybody know if such a Utopian Tool exists?


Simon Horne