# Sync Transform after modifying target database **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Natural, CONNX\ **Created:** [March 26, 2024, 2:50pm UTC](https://techcommunity.softwareag.com/t/sync-transform-after-modifying-target-database/293738 "2024-03-26T14:50:43Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![manojn](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@manojn](https://techcommunity.softwareag.com/u/manojn)\ **Post date:** [March 26, 2024, 2:50pm UTC](https://techcommunity.softwareag.com/t/sync-transform-after-modifying-target-database/293738/1 "2024-03-26T14:50:43Z")
Using ConnX web interface, create a .cdd file, connected mainframe and SQL server native client server. These server have 2 databases and trying to sync tables from IDMS mainframe to SQL server. Successfully created transformation and sync the tables. database\_1a.dbo.table\_1a \> database\_2a.dbo.table\_2a After sync, I have updated the target source (SQL server), **modified cells in target table**. And tried to sync transform again (note: while suyncing, used **select existing table** and selected the same table database\_1a.dbo.table\_1a \> database\_2a.dbo.table\_2a). But receive and **error while preforming sync after mofdification** - Error: Unable to PassPrepare. \>\>\> STAT:2 ERR:0 SQLSTATE:S1000 problems with IColumnsInfo → GetColumnsInfo()STAT:2 ERR:-2147217900 SQLSTATE:S1000 Microsoft SQL Server Native Client 11.0 : Deferred prepare could not be completed.STAT:2 ERR:-2147217900 SQLSTATE:S1000 Microsoft SQL Server Native Client 11.0 : Communication link failure (transform\_error) How to resolve this issue. **What I am trying to achieve is, once the sync is made, modified in target database, and synced again with source, I want new rows to be added, as there is modified rows different from source.** ---
**Author:** ![anon27083125](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@anon27083125](https://techcommunity.softwareag.com/u/anon27083125)\ **Post date:** [March 26, 2024, 3:07pm UTC](https://techcommunity.softwareag.com/t/sync-transform-after-modifying-target-database/293738/2 "2024-03-26T15:07:03Z")
Please kindly open a support ticket for this resolution of this issue. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [September 22, 2024, 3:07pm UTC](https://techcommunity.softwareag.com/t/sync-transform-after-modifying-target-database/293738/3 "2024-09-22T15:07:52Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.