Competition: What’s your favorite Redgate tool? Enter now.

Bundle 3 - Specified Cast is not valid error

Brian DonahueBrian Donahue Posts: 6,590 New member
edited April 20, 2005 7:24AM in Knowledge Base
  • Date: 20-April-2005
  • Products Affected: SQL Packager 1.x, SQL Data Compare 3.3.x

We have been made aware of an issue affecting SQL Data Compare and Packager that is affected by the schema of some tables that use identity columns that are marked as NOT FOR REPLICATION.

If the table has an identity column marked as IDENTITY (x,x) NOT FOR REPLICATION, and the identity column is not the primary key (or comparison key passed to Data Compare and Packager), then a specified cast is not valid error will occur when producing the migration script in either product.

We are working on correcting the problem. In the meantime, please consider working aroung it by changing the identity column to remove the NOT FOR REPLICATION constraint.
Sign In or Register to comment.