How to comair DB objects in Development server with Production server

23 Jul 2005 8:08 PM

J-T

I have couple of Stored procedures and UDFs and Tables which I generated an
script from our development server and our database admin has run that
script on the production server.Unfortunately because of some changes I had
to generate the script two more times and now I'd like to make sure that the
objects in the producation are same as development.Is there a way to compaur
tham and to see what the potential differences are?

Thanks

24 Jul 2005 12:14 AM

Narayana Vyas Kondreddi

There are many database comparison tools in the market. For example:
redgate.com

--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

Show quote

"J-T" <J-T@nospam.com> wrote in message
news:O3FEPJ8jFHA.1204@TK2MSFTNGP12.phx.gbl...
>I have couple of Stored procedures and UDFs and Tables which I generated an
>script from our development server and our database admin has run that
>script on the production server.Unfortunately because of some changes I had
>to generate the script two more times and now I'd like to make sure that
>the objects in the producation are same as development.Is there a way to
>compaur tham and to see what the potential differences are?
>
>
> Thanks
>

24 Jul 2005 3:06 PM

Aaron Bertrand [SQL Server MVP]

http://www.aspfaq.com/2209

Also, think about WinDiff if you have Visual Studio installed...

Show quote

"J-T" <J-T@nospam.com> wrote in message
news:O3FEPJ8jFHA.1204@TK2MSFTNGP12.phx.gbl...
>I have couple of Stored procedures and UDFs and Tables which I generated an
>script from our development server and our database admin has run that
>script on the production server.Unfortunately because of some changes I had
>to generate the script two more times and now I'd like to make sure that
>the objects in the producation are same as development.Is there a way to
>compaur tham and to see what the potential differences are?