Solved

Export and Import a Project-version

  • 5 March 2019
  • 3 replies
  • 116 views

What is the scenario to export a project from one SF environment and import the project into a different SF environment?
One way is of course to retype everything: the requirements, datamodel, tables, gui, etc..
I think there must be a better way to reach the same result.
icon

Best answer by Arjan Sollie 6 March 2019, 15:19

Hello Wiebe,

It is possible to copy a specific project version from one database to another. However both Software Factory databases have to be the exact same version of the Thinkwise SF Suite.

If both databases are compatible with each other, you can copy the code used in the procedure task_copy_project_vrs into a custom code. This code will copy a project version into another project version.

This code is similar to the code required to export a specific project and import this project into another database. There is only one adjustment required to enable you to copy the project into another database, you need to change the insert into (insert into new_sf_database..[table]) You can use a find and replace option to do so (replace 'insert into ', 'insert into new_sf_database..').

Notice, you will first need to create the project (target) to which you would like to copy this specific project version (source). Otherwise the copy will fail, since it only copies a project version and doesn't create a project.
View original

3 replies

Userlevel 3
Badge +4
Hello Wiebe,

It is possible to copy a specific project version from one database to another. However both Software Factory databases have to be the exact same version of the Thinkwise SF Suite.

If both databases are compatible with each other, you can copy the code used in the procedure task_copy_project_vrs into a custom code. This code will copy a project version into another project version.

This code is similar to the code required to export a specific project and import this project into another database. There is only one adjustment required to enable you to copy the project into another database, you need to change the insert into (insert into new_sf_database..[table]) You can use a find and replace option to do so (replace 'insert into ', 'insert into new_sf_database..').

Notice, you will first need to create the project (target) to which you would like to copy this specific project version (source). Otherwise the copy will fail, since it only copies a project version and doesn't create a project.
Arjan,

Thank you very much for your reaction.

It seems however that I am still in the learning curve of TSF.
I can't find the code for the task_copy_project_vrs.
How to find this?

Thank you very for your help.
Userlevel 5
Badge +7
Arjan,

Thank you very much for your reaction.

It seems however that I am still in the learning curve of TSF.
I can't find the code for the task_copy_project_vrs.
How to find this?

Thank you very for your help.


Hi Wiebe,

The Stored Procedure can be found on the SF database through the SQL Sever Management Studio ([dbname]_SF_ONT in my case), under Programmability - Stored Procedures. There you can open the code and use it for your purpose.

Kind regards,
Mark Jongeling

Reply