What are the challenges you face when working across database platforms? Take the survey

Ignoring DB Owner during comparison?

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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.


Brian Donahue
Red Gate Technical Support

"Ken" <ken@basicmicro.com> wrote in message
> 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
> this?
> Regards,
> Ken -Basic Micro
This discussion has been closed.