I am using Red Gate Oracle Schema Compare version 3 to generate migration scripts for our database.
However in going to version 4, the schema comparison with Scripts folder does not successfully interpret UserObjectPrivileges. It generates REVOKES.
How can I resolve this issue?
This might be related, but Red Gate Oracle Schema Compare version 4 also detects "objects that exist in both but are different" between the files exported to the filesystem by version 3 and the files exported to the filesystem by version 4 even though I've compared them in Notepad++ and using the command line fc /b (binary compare) and no differences are detected. I even copied and pasted one over the other, but they still are seen as "objects that exist in both but are different".
Well I asked Red Gate support and the response is as follows:
"It looks like these are intended changes. The differences you are seeing are caused by changes we have made in saving grants to the files (released in version 3.0.16). In this case it is not a bug - this is the intended action, because files now have to be rebuilt. If you wants to equal this you should deploy with these grants. After the first deploy, you should then change the comparison site and deploy again (if it shows any differences in grants again). After this actions object privileges should be compatible with the latest Schema Compare version."