Solutions
...
Interacting with Litmus Produc...
Creating a backup of a tag definition
6 min
use cases user can create backups of individual tag definitions, which will include all the id's this can be used to for example create backups of tags which are to be kept in case of a factory reset is done or if the database is to be moved to a different server after a tag definition has been restored, it is also possible to play back corresponding tag data 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 tag hierarchy backup input variables 155,141,239,219,133,114 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type how to use to create a backup of a specific tag definition, call the stored procedure prorec misc tag 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 tag hierarchy backup] @tag = n' faultcode l2 ', @device = n' l1 machine2 1 mb' ; 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 tag hierarchy backup ' order by logid desc; with the result returned