idea Re: Add Support for Bit Data Type in Replicate (SQL Server Target) in Suggest an Idea

Add Support for Bit Data Type in Replicate (SQL Server Target)

zwatkinscovermymeds — Fri, 11 Dec 2020 13:31:43 GMT

A majority of my task in consist of a PostgreSQL source replicating to a SQL Server target. If my PostgreSQL source has a boolean data type, replicate converts that to a varchar(5) and I am having to manually go into my target SQL Server databases and convert all the varchar(5) columns to bit. SQL Server then is able to do an implicit conversion when it receives a true/false from and convert the value to 1/0. I currently have ~80 task where I am having to do this manual conversion.

My understanding is that PostgreSQL and SQL Server are mature endpoints for Qlik/Attunity, so I don't understand why I am having to do this manual conversion. Am I the only one with this issue? How has this not been solved already?

Re: Add Support for Bit Data Type in Replicate (SQL Server Target)

Huey — Fri, 11 Dec 2020 14:10:55 GMT

I agree. This should be added.

Re: Add Support for Bit Data Type in Replicate (SQL Server Target)

seanhawkes — Fri, 11 Dec 2020 18:13:21 GMT

as a customer this looks very interesting and something I could make use of. Please add

Re: Add Support for Bit Data Type in Replicate (SQL Server Target)

karrasan — Tue, 15 Dec 2020 16:46:36 GMT

I strongly agree and should be added

Re: Add Support for Bit Data Type in Replicate (SQL Server Target) - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Tue, 22 Dec 2020 14:20:18 GMT

Re: Add Support for Bit Data Type in Replicate (SQL Server Target)

Huey — Mon, 26 Apr 2021 19:31:57 GMT

bump

Re: Add Support for Bit Data Type in Replicate (SQL Server Target)

zwatkinscovermymeds — Tue, 27 Apr 2021 14:38:19 GMT

This is still an issues. I would love to see this addressed in the next update 🙂

Re: Add Support for Bit Data Type in Replicate (SQL Server Target)

marina_marshak — Wed, 30 Nov 2022 14:57:35 GMT

Thank you for all your feedback, this item is now on our roadmap.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 14:59:19 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Add Support for Bit Data Type in Replicate (SQL Server Target) - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 14:59:21 GMT