Skip to main content
Solved

What happend with stored procedure post_sync in IAM?


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.
View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
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

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

This sounds like a perfect solutions :thumbsup_tone1:


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings