When a table name changes case data compare script breaks

Compares and synchronizes SQL database content.

When a table name changes case data compare script breaks

Postby hangeles » Thu May 29, 2014 9:08 pm

We occasionally have to drop a table from the source target and recreate it. I found that if we do not recreate the table name exactly case wise the data compare sdc file silently ignores them and no longer updates the data until I update the sdc to look for the 'new' name. Both databases are using SQL_Latin1_General_CP1_CI_AS collation and i do not have 'use case sensitive object definition' behavior box enabled. Am I possibly missing a step here?
hangeles
 
Posts: 4
Joined: Wed Nov 28, 2012 5:48 pm

Postby Anu Deshpande » Fri May 30, 2014 8:43 am

Thanks for your post.

I have logged a support ticket for you and will email shortly.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 735
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest