Comparing Databases

Hello,
I would like write a tool which will compare two databases
and check for differences, so can someone well me
1. Where are the database names stored
2. Where the column names are stored
3. Where the code for the views is stored
4. Where the code for the Store Procedures is stored
5. Where the code for the functions, defaults ect.
I would rather not use INFORMATION_SCHEMA views as they
look to be very database specific.
I know there are tools to do this but my company isn't
buying, and yes I have told them how much they will save
if we buy rather than make ;)
PeterCheck out:
http://www.sql-server-performance.com/vg_database_comparison_sp.asp
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:954101c3eb05$dc090b90$a101280a@.phx.gbl...
> Hello,
> I would like write a tool which will compare two databases
> and check for differences, so can someone well me
> 1. Where are the database names stored
> 2. Where the column names are stored
> 3. Where the code for the views is stored
> 4. Where the code for the Store Procedures is stored
> 5. Where the code for the functions, defaults ect.
> I would rather not use INFORMATION_SCHEMA views as they
> look to be very database specific.
> I know there are tools to do this but my company isn't
> buying, and yes I have told them how much they will save
> if we buy rather than make ;)
> Peter|||Thanks SriSamp thats perfect
Peter
>--Original Message--
>Check out:
>http://www.sql-server-
performance.com/vg_database_comparison_sp.asp
>--
>HTH,
>SriSamp
>Please reply to the whole group only!
>http://www32.brinkster.com/srisamp
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:954101c3eb05$dc090b90$a101280a@.phx.gbl...
>> Hello,
>> I would like write a tool which will compare two
databases
>> and check for differences, so can someone well me
>> 1. Where are the database names stored
>> 2. Where the column names are stored
>> 3. Where the code for the views is stored
>> 4. Where the code for the Store Procedures is stored
>> 5. Where the code for the functions, defaults ect.
>> I would rather not use INFORMATION_SCHEMA views as they
>> look to be very database specific.
>> I know there are tools to do this but my company isn't
>> buying, and yes I have told them how much they will save
>> if we buy rather than make ;)
>> Peter
>
>.
>