Generated insert script contains column nulls.

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Generated insert script contains column nulls.

Postby Geneo » Thu Mar 08, 2012 8:40 pm

Does anyone know if there is a way to exclude specific columns from the compare, but have the values populate in the sync script for inserts? I have some large tables that contain boring audit columns with different values on source and target. I'd like to ignore them for comparison purposes, yet include them in the generated insert script when the row does not exist on the target.
Posts: 2
Joined: Thu Mar 08, 2012 8:30 pm

Postby eddie davis » Thu Mar 08, 2012 9:54 pm

Thank you for your post into the forum.

Unfortunately what you are seeking to achieve is not available in SQL Data Compare.

Therefore I have updated an existing Feature Request, reference SDC-778, with the details of your forum post and marked the request for review.

Hopefully the SQL Data Compare Development Team and Product manager will review this request and include it in a future version of the product.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby Geneo » Thu Mar 08, 2012 10:13 pm

Thanks Eddie, I would use a view with "dummy" values in the audit columns, but the source database is production where I cannot create views on the fly. If there was a select option to define the table on source and target that would be great.
Posts: 2
Joined: Thu Mar 08, 2012 8:30 pm

Postby Jacquers » Mon Mar 03, 2014 3:08 pm


Has this feature request been added yet?

Posts: 9
Joined: Fri Oct 25, 2013 7:40 pm

Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests