SqlSyncProvider custom transformation

Does anyone know if it is possible to customize sync using SqlSyncProvider such that I can sync non identical databases (both sql servers) using custom transformations.

For e.g. say I have database1 containing a Person table with cols 'FirstName' and 'LastName', and I have database2 with Person table with a single column 'Name' and I want the sync to transform database2.Pers开发者_运维知识库on.Name = database1.Person.FirstName + database1.Person.LastName.

Regards,

Ilias

---

that should be possible. you can provision the tables as it is, but intercept the changes and manipulate them.

check out a similar approach here:

Synching with different column keys

Part 4 – Synchronizing Tables With Different Table Names and Column Names

the process should be almost the same.