Comparing Databases in a .Net Application

[Stephen]

I have to write a .Net application which can compare SQL Databases including
things like: -
DB structure, PK's, FK's,
indexes and types of indexes i.e. should be able to detect if the same index
has cascade set on one db and not on another, or unique on one and not the
other,
Constraints, Triggers, Stored procs, Users, Roles.
I downloaded the SQL Data Compare 3.0 application 14 day trial and it seemed
really good however does a bit more than I am required and I have to design
an application tailored to my businesses needs. At present there is a system
in VB.6.0 but I have to design a C#.net application using the latest SQL
objects available to do this. I was wondering if anyone could point me in
the direction of any source code/ solutions I could look at for .net which
allow me to compare databases. Or if anyone had any help and could point me
in the right direction I would be very greatful. Thank you very much. Even
if anyone know what objects are available in .net to compare databases I
would be very grateful

[Bonj]

System stored procedures can be good, for example
sp_helpindex '<tablename>'

to give you the indexes on a table

have a look through them all and harvest as much as you can from there
"Stephen" wrote:

I have to write a .Net application which can compare SQL Databases including
things like: -
DB structure, PK's, FK's,
indexes and types of indexes i.e. should be able to detect if the same index
has cascade set on one db and not on another, or unique on one and not the
other,
Constraints, Triggers, Stored procs, Users, Roles.
I downloaded the SQL Data Compare 3.0 application 14 day trial and it seemed
really good however does a bit more than I am required and I have to design
an application tailored to my businesses needs. At present there is a system
in VB.6.0 but I have to design a C#.net application using the latest SQL
objects available to do this. I was wondering if anyone could point me in
the direction of any source code/ solutions I could look at for .net which
allow me to compare databases. Or if anyone had any help and could point me
in the right direction I would be very greatful. Thank you very much. Even
if anyone know what objects are available in .net to compare databases I
would be very grateful

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

In MS SQL there are several tables named sysXXX , in especial one named
sysobjects will contain all objects in your db (I think ) including all SP,
PK/FK/Tables etc

Take a look at the documentation and/or ask in the SQL NG for details about
the system tables. There is all what you need.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Stephen" <St*****@discus sions.microsoft .com> wrote in message
news:C9******** *************** ***********@mic rosoft.com...

I have to write a .Net application which can compare SQL Databases including things like: -
DB structure, PK's, FK's,
indexes and types of indexes i.e. should be able to detect if the same index has cascade set on one db and not on another, or unique on one and not the
other,
Constraints, Triggers, Stored procs, Users, Roles.
I downloaded the SQL Data Compare 3.0 application 14 day trial and it seemed really good however does a bit more than I am required and I have to design an application tailored to my businesses needs. At present there is a system in VB.6.0 but I have to design a C#.net application using the latest SQL
objects available to do this. I was wondering if anyone could point me in
the direction of any source code/ solutions I could look at for .net which
allow me to compare databases. Or if anyone had any help and could point me in the right direction I would be very greatful. Thank you very much. Even if anyone know what objects are available in .net to compare databases I
would be very grateful