How to compare two databases using their DDLs?

Hello all!

My question is: how to compare two database structures if I only have
their DDL files? As the result I would expect an sql-script upgrating
one database structure to another.

The most 3rd-party tools I tested require connection to both databases.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Evgeny Gopengauz" <evgop@.ucs.ru> wrote in message
news:4124caa2$0$14418$c397aba@.news.newsgroups.ws.. .
> Hello all!
> My question is: how to compare two database structures if I only have
> their DDL files? As the result I would expect an sql-script upgrating
> one database structure to another.
> The most 3rd-party tools I tested require connection to both databases.
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Personally, I would use the DDL to create two databases, then compare them
with a tool. If you want to be able to compare two databases without having
MSSQL available, then you would have to look for a tool which supports that.
I believe ERwin does, although I'm not sure (and it's rather expensive).

Simon