Activity overview
Latest activity by coavlanche
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...
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...
SQL Compare Command-Line Exit Code
I am using SQLCompare (13.4.8) within an SSIS package and invoking a project with the following command-line:SQLCompare.exe /project:"\\PathToProject\Project.scp" /sync /include:IdenticalWhen this ...
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 ...
Question regarding privileges
Can someone tell me what privileges are required to deploy Oracle changes to the target database? These deploy scripts potentially include create table scripts. That's not such a big deal as the ...
Is there a way to include Temporary tables in compare?
I need to compare/sync a view in one database to scripts, and then compare/sync that script to a TABLE in a database in another environment. I was going to do a "Select * INTO ##TempTable FROM Tab...
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...
Object Reference when comparing
I am using SQL Compare to compare a SQL database (only one table selected) to a script folder and then doing a deploy to that script folder. I am then doing a compare from that script folder again...
Ignore Foreign Keys
For the life of me I can't figure out how to ignore foreign keys when doing a compare. I've looked in the docs and tried every option I can think of and it still includes Foreign Keys, which I don...
Thanks! I may give that a try. / comments
Thanks! I may give that a try.