Connecting Tech Pros Worldwide Forums | Help | Site Map

How to compare two databases using their DDLs?

Evgeny Gopengauz
Guest
 
Posts: n/a
#1: Jul 20 '05
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!

Simon Hayes
Guest
 
Posts: n/a
#2: Jul 20 '05

re: How to compare two databases using their DDLs?



"Evgeny Gopengauz" <evgop@ucs.ru> wrote in message
news:4124caa2$0$14418$c397aba@news.newsgroups.ws.. .[color=blue]
> 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![/color]

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


Closed Thread