Comments
Sort by recent activity
I figured out my issue. Turns out it was Windows UAC not allowing access to all of the SQL Compare dll's and/or .Net framework. Here is how SQLCompare (Or any process) can be called from within SSIS.[image] I can't show a screenshot of the exit code as it's not a visible process and is being executed by SSIS. / comments
I figured out my issue. Turns out it was Windows UAC not allowing access to all of the SQL Compare dll's and/or .Net framework.Here is how SQLCompare (Or any process) can be called from within SSI...
Thanks Martin, this is good info! We would like to have a super user that can create/modify in all schemas that we're deploying to, but it seems like the only way to achieve that is to grant that user DBA rights, which is less than ideal from a security perspective. We did try the option in the documentation of 'GRANT
GRANT ANY OBJECT PRIVILEGE to <user>' however that seems to fall short when you have a constraint that needs to be created, possibly other actions as well. / comments
Thanks Martin, this is good info! We would like to have a super user that can create/modify in all schemas that we're deploying to, but it seems like the only way to achieve that is to grant that ...
Did you ever resolve this issue? I'm having a very similar error as this. I have an SSIS package which executes SQL Compare from within the package (command-line). The SSIS package is executed via SQL Agent Job that is using a proxy account. I have tried everything I can think of. If I run the SQL Agent Job under the SQL Agent account and don't use a proxy, it works. / comments
Did you ever resolve this issue? I'm having a very similar error as this. I have an SSIS package which executes SQL Compare from within the package (command-line). The SSIS package is executed v...
Michelle T said:
Not currently - the object names aren't encrypted, they're compressed (because you can end up with some very large project files otherwise). Instead of trying to use the project file, you can generate an XML report of a comparison (either via the command line or Generate Comparison Report from the Tools menu), which you may be able to use in a similar fashion?
That isn't going to work for me. I need to be able to read the objects being compared in XML in the project file so that I can do some processing before the compare runs. With Oracle Schema Compare, this is easy to do as the object names aren't compressed. Is there a back-rev version of SQL Compare which doesn't compress these values, and if so could I use that version to create the project file and then use that (older) project file to run the compare with version 13? I know it's a long shot but without this things are going to get very complicated. / comments
Michelle T said:
Not currently - the object names aren't encrypted, they're compressed (because you can end up with some very large project files otherwise).Instead of trying to use the proje...
Thanks! I may give that a try. / comments
Thanks! I may give that a try.