Ignoring DB Owner during comparison?

Brian DonahueBrian Donahue Posts: 6,590 New member
edited December 22, 2003 10:48AM in SQL Compare Previous Versions
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" <[email protected]> wrote in message
news:[email protected]
> 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.