How can we help you today? How can we help you today?
RichR
Activity overview Badges (0) Posts (1) Comments (5)

Activity overview

Latest activity by RichR

Peter, I have isolated the issue. It is not related to table names as I thought earlier. The error occurs when the table listed in the "db2" database has extra columns that are not in the table on the "db1" database AND you attempt to use those extra columns in the ExcludeColumns parameter. The error does not occur when you switch the position of the two databases. I have created scripts that illustrate the issue. Let me know how and I will send them to you. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Error using SQLDataCompare command line and ExcludeColumns
Peter, I have isolated the issue. It is not related to table names as I thought earlier. The error occurs when the table listed in the "db2" database has extra columns that are not in the table o...
0 votes
Peter, I'm setting up an example that I can provide you. I've found that it has something do to with there being more than one table with the selected name in the database (i.e., if we have Distribution, Distribution_To, Distribution_From in the source and destination databases, then the error occurs). I will package up a set of example scripts for you today. How can I deliver the files to you? / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Error using SQLDataCompare command line and ExcludeColumns
Peter, I'm setting up an example that I can provide you. I've found that it has something do to with there being more than one table with the selected name in the database (i.e., if we have Distri...
0 votes
More information: The table and column names have different capitalization. In Database1 - DISTRIBUTION.LAST_MOD_DT In Database2 - Distribution.Last_Mod_Dt / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Error using SQLDataCompare command line and ExcludeColumns
More information: The table and column names have different capitalization. In Database1 - DISTRIBUTION.LAST_MOD_DT In Database2 - Distribution.Last_Mod_Dt
0 votes
Peter - The option you suggested did not work. I am still receiving the same error. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Error using SQLDataCompare command line and ExcludeColumns
Peter - The option you suggested did not work. I am still receiving the same error.
0 votes
Thanks Peter, I will try it this morning and get back to you. / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Error using SQLDataCompare command line and ExcludeColumns
Thanks Peter, I will try it this morning and get back to you.
0 votes
Error using SQLDataCompare command line and ExcludeColumns
  1. Community
  2. SQL Data Compare Previous Versions
I have an issue using the command line version of SQLDataCompare (version 8.1.0.4). I'm trying to run a comparison of the 'Distribution' table, but I want to ignore the 'last_mod_dt' column. When ...
2 followers 8 comments 0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1