idea Re: Enabling inline replication from Oracle to SQL server database for LOB columns. in Suggest an Idea

Enabling inline replication from Oracle to SQL server database for LOB columns.

atkari — Thu, 28 Jan 2021 20:29:53 GMT

Hi Team,

In our environment, on source side we have 4 columns primary key and 1 column value from this combination gets changed before this record gets replicated to target. Due to that, LOB lookup fails on target as the PK is different from the one we are trying to make the lookup.

We want Attunity product support team to check if they can enable inline replication for PK so that even if change in PK at source side, will not cause any problem in replication of LOBS on target side.

Re: Enabling inline replication from Oracle to SQL server database for LOB columns.

Meghann_MacDonald — Tue, 01 Sep 2020 21:39:42 GMT

Hi @atkari ,

You said in the post that you want Attunity support to check if this can be enabled. Did you go through support before submitting this idea? We are not working with support. Please see the Ideation Rules Post for clarification and let me know.

Meghann

Re: Enabling inline replication from Oracle to SQL server database for LOB columns.

atkari — Sun, 27 Sep 2020 14:39:15 GMT

Hi Meghann,

Yes we did raised ticket with support. (Case No 02023051) and post suggestion from support I raised this FR.

Please let me know if you need any more details for further investigation on this topic.

Regards,

Sachin Atkari.

Re: Enabling inline replication from Oracle to SQL server database for LOB columns. - Status changed to: Open - New

Shelley_Brennan — Mon, 11 Jan 2021 14:35:13 GMT

Can you provide the table definition that is not working so we can see the maximum size and type of the LOB columns? Thank you.

Re: Enabling inline replication from Oracle to SQL server database for LOB columns.

Shelley_Brennan — Tue, 01 Jun 2021 12:23:16 GMT

Can you provide the table definition that is not working so we can see the maximum size and type of the LOB columns? Thank you.

Re: Enabling inline replication from Oracle to SQL server database for LOB columns. - Status changed to: Closed - Archived

Shelley_Brennan — Fri, 23 Jul 2021 17:21:39 GMT

We can revisit if we get the table definition. Thank you!