https://community.qlik.com/t5/Qlik-Replicate/Moving-a-source-from-Azure-Sql-Managed-Instance-ms-cdc-to/m-p/2111001#M7167 <P>We are moving our source from Azure SMI to Windows SQLServer.&nbsp; &nbsp;The source both have different source types in the end-point (due to licensing...etc).</P> <P>Described in the original endpoint (azure smi (ms-cdc)) are 400 or so tables, some with transforms, all have been tagged for load priority...in other words a lot of effort went into the endpoint.</P> <P>We then created a new endpoint (for SqlServer (MS-CDC), it starts out devoid of transforms, tables...etc.&nbsp;</P> <P>The UI allows for an endpoint to be duplicated (and that preserves the 400 table and setups), however duplicated endpoints do not allow the source type to be changed!&nbsp;</P> <P>Given that, it looks like we are forced to manually add the 400 tables (easy enough), but we are still left with the task of re-creating the transforms and the prioritizations.&nbsp; Yuck!</P> <P>Is there any hack to change the endpoint type on a duplicated endpoint...like edit a file or ???</P> <P>This all on May2023 latest release of Replicate</P> <P>Ron</P> <P>&nbsp;</P> Tue, 29 Aug 2023 16:09:06 GMT RonFusionHSLLC 2023-08-29T16:09:06Z https://community.qlik.com/t5/Qlik-Replicate/Moving-a-source-from-Azure-Sql-Managed-Instance-ms-cdc-to/m-p/2111001#M7167 <P>We are moving our source from Azure SMI to Windows SQLServer.&nbsp; &nbsp;The source both have different source types in the end-point (due to licensing...etc).</P> <P>Described in the original endpoint (azure smi (ms-cdc)) are 400 or so tables, some with transforms, all have been tagged for load priority...in other words a lot of effort went into the endpoint.</P> <P>We then created a new endpoint (for SqlServer (MS-CDC), it starts out devoid of transforms, tables...etc.&nbsp;</P> <P>The UI allows for an endpoint to be duplicated (and that preserves the 400 table and setups), however duplicated endpoints do not allow the source type to be changed!&nbsp;</P> <P>Given that, it looks like we are forced to manually add the 400 tables (easy enough), but we are still left with the task of re-creating the transforms and the prioritizations.&nbsp; Yuck!</P> <P>Is there any hack to change the endpoint type on a duplicated endpoint...like edit a file or ???</P> <P>This all on May2023 latest release of Replicate</P> <P>Ron</P> <P>&nbsp;</P> Tue, 29 Aug 2023 16:09:06 GMT https://community.qlik.com/t5/Qlik-Replicate/Moving-a-source-from-Azure-Sql-Managed-Instance-ms-cdc-to/m-p/2111001#M7167 RonFusionHSLLC 2023-08-29T16:09:06Z https://community.qlik.com/t5/Qlik-Replicate/Moving-a-source-from-Azure-Sql-Managed-Instance-ms-cdc-to/m-p/2111055#M7169 <P>Nevermind...figured it out.</P> <P>Exported original json, exported new json with just enough to get started...</P> <P>Carefully, moved tag sections from original to new...</P> <P>Imported new</P> <P>Worked like a charm</P> Tue, 29 Aug 2023 19:00:29 GMT https://community.qlik.com/t5/Qlik-Replicate/Moving-a-source-from-Azure-Sql-Managed-Instance-ms-cdc-to/m-p/2111055#M7169 RonFusionHSLLC 2023-08-29T19:00:29Z