Replacing Values

Compares and synchronizes SQL database content.

Moderators: Chris Auckland, David Atkinson, richardjm, david connell

Replacing Values

Postby Ericgagne » Wed Feb 22, 2012 7:32 pm

Hello,

I'm synchronizing tables from 2 different databases that were used in different companies. I need to be able to change the value in one of the columns with a fixed value instead of the value in the source table.

Can I do this without having to copy/paste all my scripts in SSMS to modify them ?
Ericgagne
 
Posts: 5
Joined: Wed Sep 16, 2009 3:09 pm

Postby eddie davis » Wed Feb 22, 2012 9:53 pm

Thank you your post into the forum.

Unfortunately you have to load your scripts into SSMS and modify them to update with your fixed value.

SQL Data Compare was designed for the user to compare two data sources and generate a synchonization script so that both data sources become identical.

You could possiblily achieve what you are seeking using our SQL Data Generator product, where post synchronization using SQL Data Compare, you use SQL data Generator to update the required columns with your fixed value.

Further information regarding SQL Data Generator can be found here.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby Ericgagne » Wed Feb 22, 2012 9:58 pm

Hi Eddie,

Thanks for the reply. Unfortunately it's not an option for me to change my values after synchronizing. The destination table has triggers on these columns that make sure the values exists in their corresponding master tables.

The sripts will abort if I don't change the values before running them.
Ericgagne
 
Posts: 5
Joined: Wed Sep 16, 2009 3:09 pm

Postby David Atkinson » Wed Feb 22, 2012 10:07 pm

This may be possible by creating a view in your source database that only selects from the columns you want to synchronize.

You can map this View with your target Table.

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests