Ignoring DB Owner during comparison?
Brian Donahue
Posts: 6,590 Bronze 1
Hi Ken,
SQL Compare will not let you compare tables with different owners. It
treats them as wholly different objects. We can't find any workarounds using
SQL Server other than execing an sp_changeobjectowner on the database
object, at least temporarily, to change the object owner in the second
database to match the owner of the object in the first.
Thanks,
Brian Donahue
Red Gate Technical Support
"Ken" <ken@basicmicro.com> wrote in message
news:lAsFbZlxDHA.1552@server53...
> Hello,
>
> Is there anyway to ignore the db owner when doing a comparison?
>
> Example: My development database owner is [dbo] but my production db owner
> may be different example [production]. Does anyone know of a workaround
for
> this?
>
> Regards,
> Ken -Basic Micro
>
>
SQL Compare will not let you compare tables with different owners. It
treats them as wholly different objects. We can't find any workarounds using
SQL Server other than execing an sp_changeobjectowner on the database
object, at least temporarily, to change the object owner in the second
database to match the owner of the object in the first.
Thanks,
Brian Donahue
Red Gate Technical Support
"Ken" <ken@basicmicro.com> wrote in message
news:lAsFbZlxDHA.1552@server53...
> Hello,
>
> Is there anyway to ignore the db owner when doing a comparison?
>
> Example: My development database owner is [dbo] but my production db owner
> may be different example [production]. Does anyone know of a workaround
for
> this?
>
> Regards,
> Ken -Basic Micro
>
>
This discussion has been closed.
