Creating a backup of a data model configuration

use cases user can create backups of individual data models, which will include all the id's this can be used to for example create backups of all the models which are to be kept before a factory reset is done or if the database is to be moved to a different server after a data model has been restored, it is also possible to paly back corresponding production records user can do this either by using applications such as microsoft sql server management studio mssql cli this can also be used for building custom solutions based on applications which allow for an odbc connection such as excel c# net python method execute stored procedure prorec misc hierarchy backup input variables variable name datatype description example @node varchar(50) the name of the root node and the name of the data model mandatory! can not be null or empty urethanes how to use to create a backup of a specific data model configuration, call the stored procedure prorec misc hierarchy backup using the t sql exec or execute keyword and provide the input variables below is an example using t sql in sql server management studio execute \[le productionrecord] \[dbo] \[prorec misc hierarchy backup] @node = n'urethanes'; if an output window does exist, the progress can be observed result the stored procedure will verify that the provided values are correct and then create the backup the result can be read back from the log table prorec misc log below is an example using t sql in sql server management studio select top (100) \[logid] ,\[logtype] ,\[logprocedure] ,\[logentry] ,\[logtime] from \[le productionrecord] \[dbo] \[prorec misc log] where \[logprocedure] = 'prorec misc hierarchy backup' order by logid desc; with the result returned