SQL Server connector's V2 actions and triggers by 31 March 2024

Question

SQL Server connector's V2 actions and triggers by 31 March 2024

Manoj Kumar - ERS, HCL Tech 0

Hi I have azure logic app written in C# using azure sql connection string as configuration running in azure portal, I got this alert mail change Sql connecter from v1 to v2, now in logic app settings or azure Sql setting not able to find any connecter related settings, How can I change Sql connecter from V1 to V2

With Regards

Manoj Kumar

v-mkumar3@microsoft.com

JananiRamesh-MSFT 29,261 Reputation points

2023-12-11T15:46:01.4433333+00:00

@Manoj Kumar - ERS, HCL Tech Just a follow up on my previous comment and see if you have any questions. I would be happy to answer your questions. Thanks.
JananiRamesh-MSFT 29,261 Reputation points

2023-12-18T10:05:32.1366667+00:00

@Manoj Kumar - ERS, HCL Tech Following up to see if my answer helps. Do let me know if you have any queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.
Manoj Kumar (HCL TECHNOLOGIES) 0 Reputation points

2023-12-19T05:03:28.5933333+00:00

Thanks u a lot for reply, I have 1 app service written in c# and 2nd as web job written also in c# both are using sqlclient package reference 4.8.5 and connection string is it causing connecter issue of V1, my old, referenced logic app is not using any SQL at all.
JananiRamesh-MSFT 29,261 Reputation points

2023-12-21T08:12:48.0533333+00:00

@Manoj Kumar - ERS, HCL Tech Thanks for getting back, The version of the System.Data.SqlClient package that you are using (4.8.5) should not cause any issues with the SQL connector version in Azure Logic Apps. The SQL connector version is determined by the connector that you select when you create a connection in your Logic App.

If your old referenced Logic App is not using any SQL, then it should not be affected by the SQL connector version change.

I hope that helps! Let me know if you have any other questions.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

1 answer

Your answer

JananiRamesh-MSFT 29,261 Reputation points

2023-12-11T15:46:01.4433333+00:00

@Manoj Kumar - ERS, HCL Tech Just a follow up on my previous comment and see if you have any questions. I would be happy to answer your questions. Thanks.
JananiRamesh-MSFT 29,261 Reputation points

2023-12-18T10:05:32.1366667+00:00

@Manoj Kumar - ERS, HCL Tech Following up to see if my answer helps. Do let me know if you have any queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.
Manoj Kumar (HCL TECHNOLOGIES) 0 Reputation points

2023-12-19T05:03:28.5933333+00:00

Thanks u a lot for reply, I have 1 app service written in c# and 2nd as web job written also in c# both are using sqlclient package reference 4.8.5 and connection string is it causing connecter issue of V1, my old, referenced logic app is not using any SQL at all.
JananiRamesh-MSFT 29,261 Reputation points

2023-12-21T08:12:48.0533333+00:00

@Manoj Kumar - ERS, HCL Tech Thanks for getting back, The version of the System.Data.SqlClient package that you are using (4.8.5) should not cause any issues with the SQL connector version in Azure Logic Apps. The SQL connector version is determined by the connector that you select when you create a connection in your Logic App.

If your old referenced Logic App is not using any SQL, then it should not be affected by the SQL connector version change.

I hope that helps! Let me know if you have any other questions.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Answer 1

JananiRamesh-MSFT 29,261

@Manoj Kumar - ERS, HCL Tech Thanks for reaching out. There are no settings available to directly change from V1 to V2. You would need to follow our detailed steps to migrate your V1 SQL Server connector’s operations to the SQL Server connector’s V2 actions and triggers.

please let me know if you have any queries. I would be happy to assist you.

Share via

SQL Server connector's V2 actions and triggers by 31 March 2024

1 answer

Your answer