Edit Table-to-Table Sync Rul.

KCHERDAL · March 20, 2019 1:27PM

Hello,

Hello, I am trying to fill the use the Edit Table-to-Table Sync Rul. I am not awear how can I enable the

"Where Clause" any example of the syntax.

my need is : when I mask NOM row in TEST table the same time update Row NOM in TEST2 table where NOM=LONDON

Thanks an advance,

Khalil

Eddie D · March 22, 2019 10:54AM

Hi,
Thank you for your forum post.

Does the advice in the following article answer your question regarding the Table-To-Table Synchronization Rule.

Many Thanks
Eddie

KCHERDAL · March 25, 2019 11:55AM

Hello Eddie,

Thanks for your answer, I already see the documentation but isn't clear . I want user the Where caluse so do you have any example ?

Thanks an advance,

Khalil CHERDAL

Alex B · April 1, 2019 10:03AM

Hi @KCHERDAL,

This page goes over WHERE Clauses. I believe it would look like this:

Image: https://redgatesupport.zendesk.com/attachments/token/3oMXdzFRla847eCHBaD4VXtx2/?name=inline-2094791606.png

Where you are applying the WHERE to the TARGET.

I hope that helps!

Kind regards,
Alex

Searching · April 17, 2019 1:40PM

This is helpful because the documentation is hard to understand for editing.

Edit Table-to-Table Sync Rul.

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk