Compare Schema's...XSD

[Shock]

Hey all,

I am currently researching ways to compare databases via an XSD schema.
I wrote a small app that creates a dataset from a database and exports
that dataset to XSD. This gives me an XSD file with tables and
relationships representing the entire database.

At this point, I am trying to find ways to compare these schemas. Does
anybody know of a way to do this easily and to record differences if
there are any?

Also, any information on comparing databases using any method would be
greatly appreciated.

Thanks,

--
Shock

[Erland Sommarskog]

Shock ([e-mail]) writes:

I am currently researching ways to compare databases via an XSD schema.
I wrote a small app that creates a dataset from a database and exports
that dataset to XSD. This gives me an XSD file with tables and
relationships representing the entire database.

At this point, I am trying to find ways to compare these schemas. Does
anybody know of a way to do this easily and to record differences if
there are any?

Also, any information on comparing databases using any method would be
greatly appreciated.

My knowledge on XSD is weak, so I skip that question. For comparing
databases in general, a common recommendation is Red Gate's SQL Compare,
although I have never used it myself.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Shock]

Erland Sommarskog wrote:

Shock ([e-mail]) writes:

I am currently researching ways to compare databases via an XSD schema.
I wrote a small app that creates a dataset from a database and exports
that dataset to XSD. This gives me an XSD file with tables and
relationships representing the entire database.

At this point, I am trying to find ways to compare these schemas. Does
anybody know of a way to do this easily and to record differences if
there are any?

Also, any information on comparing databases using any method would be
greatly appreciated.

My knowledge on XSD is weak, so I skip that question. For comparing
databases in general, a common recommendation is Red Gate's SQL Compare,
although I have never used it myself.

I actually tested their software and it was quite good, but we can't use
it because of their licensing. They even provide an API that can be
used in .NET, but their licensing methods are terrible...read the fine
print.

--
Shock

[John McGrath]

I'd recommend you have a look at Innovartis DB Ghost at
http://www.innovartis.co.uk/

John McGrath
SQL Server DBA MCSE

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!