Skip to main content
Answer

What happend with stored procedure post_sync in IAM?

  • July 16, 2019
  • 4 replies
  • 231 views

Harm Horstman
Superhero
Forum|alt.badge.img+21
Until 2018.3 there was the post_sync procedure, which could be used to execute some statements after the synchronization process.

The main reason why I am asking, is because I like to execute this statement after every sync:

EXEC [dbo].[task_switch_path] @project_id = @project_id, @project_vrs_id = @project_vrs_id, @old_path = 'S:\Thinkwise\Applications\', @new_path = 'Applications\', @use_iam_project = 0

Is there any alternative?

Best answer by Jeroen van den Belt

Hello Harm,

Thank you for posting your question. We'll look into the possibilty to reinstate the post_sync procedure into our new synchronization mechanism. We'll keep you posted when there are any updates.
This topic has been closed for replies.

4 replies

Jeroen van den Belt
Administrator
Forum|alt.badge.img+10
Hello Harm,

Thank you for posting your question. We'll look into the possibilty to reinstate the post_sync procedure into our new synchronization mechanism. We'll keep you posted when there are any updates.

Harm Horstman
Superhero
Forum|alt.badge.img+21
  • Author
  • Superhero
  • January 29, 2020

Any progress on this topic?


Anne Buit
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • February 11, 2020

Hi Harm,

We plan to include this in version 2020.2.

However, it will work a bit different than it used to. Post-sync SQL code will be configurable in the Software Factory at the synchronization screen and deployment package screen.

This code will be executed on IAM after synchronization, when synchronizing directly to IAM and when a deployment package is created and executed via the deployer.

The SQL code will be part of the model and will be retained after the synchronization run or deployment package creation, so it can be used again in the next run.

This way, you won't have to change any procedures on IAM (which is tricky when upgrading).


Harm Horstman
Superhero
Forum|alt.badge.img+21
  • Author
  • Superhero
  • February 24, 2020

This sounds like a perfect solutions :thumbsup_tone1: