| Author |
How to comair Database objects
|
|
|
| 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
| |
| John Bell 2005-07-23, 8:24 pm |
| Hi
Using a version control system should stop this occuring. You can use dmo to
compare objects or possibly a third party application such as dbghost
www.dbghost.com or red gate compare www.red-gate.com .
John
"J-T" <J-T@nospam.com> wrote in message
news:%23Jr%238I8jFHA
.3048@TK2MSFTNGP10.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
>
| |
|
| The red-gate is awesome.
Thanks a lot
"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:u6Z%23yP8jFHA.3144@TK2MSFTNGP12.phx.gbl...
> Hi
>
> Using a version control system should stop this occuring. You can use dmo
> to compare objects or possibly a third party application such as dbghost
> www.dbghost.com or red gate compare www.red-gate.com .
>
> John
>
> "J-T" <J-T@nospam.com> wrote in message
> news:%23Jr%238I8jFHA
.3048@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|