Solved

What happend with stored procedure post_sync in IAM?

  • 16 July 2019
  • 4 replies
  • 184 views

Userlevel 6
Badge +14
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?
icon

Best answer by Jeroen van den Belt 17 July 2019, 11:30

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

4 replies

Userlevel 5
Badge +4
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.
Userlevel 6
Badge +14

Any progress on this topic?

Userlevel 6
Badge +4

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).

Userlevel 6
Badge +14

This sounds like a perfect solutions :thumbsup_tone1:

Reply