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

Excessive changes

jstangroomejstangroome Posts: 26
edited February 28, 2007 10:58PM in SQL Compare Previous Versions
I have changed the REFERENCES permission on a user defined type in one database and I am trying to sync that to another. In this minimal case, the only change required on target db is:

REVOKE REFERENCES ON TYPE::dbo.mytype TO public
GRANT REFERENCES ON TYPE::dbo.mytype TO MyUser

But the output from SQL Compare insists on dropping and recreating the type then granting permissions.

Highly referenced types become troublesome as SQL Compare will remove all references to the type before the changes, then recreate the references after the permission change.

Is there a side-effect I'm not aware of?

Thanks,

- Jason
Sign In or Register to comment.