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

Permission Problems

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited April 20, 2004 6:18AM in SQL Compare Previous Versions
Hi Lee,

You may want to check that the 'Ignore Permissions' option is turned
off. If you're migrating database objects with SQL Compare without moving
the permissions on them, you might be missing some important rights for your
particular login.

Please give that a look and tell us if you have any success.


Brian Donahue
Red Gate Technical Support

"Lee Barrett" <lee.home@eupa.co.uk> wrote in message
> Firstly I am no expert with SQL.
> Up until now I only have a little experience with Enterprise manager. A
> couple of days ago I downloaded SQL Compare and SQL Data compare.
> When using SQL Compare to copy a number of DB tables from a local SQL DB
> a remote SQL DB all appears to be OK except when I then examine the remote
> DB tables in Enterprise Manager I find that I have lost functionality on
> these tables, like the 'Design Table' option or delete option. I think
> may be something to do with permissions ?
> Am I right and how do I prevent this from happening ?
> I am considering purchasing the SQL Compare Bundle so would appreciate
> sorting this problem out,
> Kind Regards
> Lee BArrett
This discussion has been closed.