How can we help you today? How can we help you today?
Al C
Activity overview Badges (0) Posts (4) Comments (2)

Comments

Sort by recent activity
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
  1. Community
  2. SQL Data Compare Previous Versions
  3. New Schema is not showing up in mapping
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 ...
0 votes
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
  1. Community
  2. SQL Data Compare Previous Versions
  3. Exit Code 63
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 ...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2