Activity overview
Latest activity by Al C
All tables becoming selected after execution of project.
We have a SqlDataCompare project (version 5.2.0.40
) that is executed from a monthly SSIS package. The command line is something like this:
/project:"C:\Documents and Settings\Administrator\Local ...
I am using the sa account so I should be able to view all objects. Can you try this. Create a new schema like this:
CREATE SCHEMA rpt
Then add some tables within this new 'rpt' schema and let me know if they appear in SqlDataCompare. Thanks. / comments
I am using the sa account so I should be able to view all objects. Can you try this. Create a new schema like this:
CREATE SCHEMA rpt
Then add some tables within this new 'rpt' schema and let me ...
New Schema is not showing up in mapping
I am trying to compare tables in 2 databases on different servers (both are SQL 2005). I have SqlDataCompare 5.3.0.68. The problem is that I created a new schema called 'rpt' on both databases an...
Yes, that is how I used to do it in DTS. I found a workaround in SSIS. What I do is I set the FailTaskIfReturnCodeIsNotSuccess to False, and then in a subsequent step I test the ReturnCode for 0 or 63. If it is not one of those, then I fail the task. / comments
Yes, that is how I used to do it in DTS. I found a workaround in SSIS. What I do is I set the FailTaskIfReturnCodeIsNotSuccess to False, and then in a subsequent step I test the ReturnCode for 0 ...
Exit Code 63
I would love it if I could tell Sql Data Compare not to produce exit code 63 when the tables being compared are identical. I am executing Sql Data Compare from within a Sql Server Integration Serv...
How to specify WHERE Clause filter in commandline interface?
I have a WHERE clause filter in my SQLDataCompare. I want to automate the DataCompare using the commandline options. I have it set up except for the WHERE clause. How do I incorporate it into th...