Sushant here i found some thing for you , i hope that will help ...
http://searchwin2000.techtarget.com/tip/1,289483,sid1_gci814915,00.html
Note the one thing it does not compare is
referential constraints (new to SQL2000) but it does give a good comparison.
Rgards,
Usman
-----Messaggio originale-----
Da: Sushant Saha [mailto:[Email Address Removed] Wednesday, February 19, 2003 11:45 AM
A: LazyDBA.com Discussion
Oggetto: RE: SQL database Comparing between two database.
But this on is not freeware. It's got a Trail Version. Instead of GUI I need
a complete SQL script, Or a Stored procedure.
-----Original Message-----
From: Hervén Stefan [mailto:stefan.[Email Address Removed] 19 February 2003 10:42
To: LazyDBA.com Discussion
Subject: RE: SQL database Comparing between two database.
I have an excellent freeware that I'm using every day... SQL Server
Compare... do a search on the internet. I don't remember where I downloaded
it.
/Stefan
-----Original Message-----
From: Usman Farhat [mailto:Usman.[Email Address Removed] den 19 februari 2003 11:41
To: LazyDBA.com Discussion
Subject: R: SQL database Comparing between two database.
Hi Everyone,
If some one have any idea about this matter , as it is very useful thing to
have a script for Comparing Structure of two Datbases and it can help in
many ways to DBA,
Please any Comments and any ideas ?
Thanks a lot for your people concern,
Usman
-----Messaggio originale-----
Da: Sushant Saha [mailto:[Email Address Removed] Tuesday, February 18, 2003 5:47 PM
A: LazyDBA.com Discussion
Oggetto: SQL database Comparing between two database.
Hi,
Does anybody got a SQL Script to compare all database object ( table, Views,
Stored Proc, triggers etc) between two different SQL 2000 database.
And finally produce a report out of it. I know there are few tools available
but I need the SQL script or a stored procedure instead.
Thanks,
Sushant
Disclaimer: Any views or opinions expressed in this e-mail and its
attachments are solely those of the author and do not necessarily represent
those of PIMS UK Limited.
Confidentiality: This e-mail and its attachments are solely intended for the
ordinary user of the e-mail address to which it was addressed and may be
confidential. If they have come to you in error you must take no action
based on them, nor must you copy or show all or any of them to anyone. If
you receive this e-mail in error, we should be obliged if you would e-mail
our postmaster at [Email Address Removed] and highlight the error. Thank you.
Security Warning: Please note that this e-mail has been created in the
knowledge that internet e-mail is not a 100% secure communications medium.
We advise that you understand and observe this lack of security when
e-mailing us.
Viruses: Although we have taken steps to ensure that this e-mail and
attachments are free from any virus, we advise that in keeping with good
computing practice the recipient should ensure they are actually virus free.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] Any views or opinions expressed in this e-mail and its attachments are solely those of the author and do not necessarily represent those of PIMS UK Limited.
Confidentiality: This e-mail and its attachments are solely intended for the ordinary user of the e-mail address to which it was addressed and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show all or any of them to anyone. If you receive this e-mail in error, we should be obliged if you would e-mail our postmaster at [Email Address Removed] and highlight the error. Thank you.
Security Warning: Please note that this e-mail has been created in the knowledge that internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us.
Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
MS Sql Server LazyDBA home page