Creating a backup of a data model configuration
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
Execute Stored Procedure PROREC_Misc_Hierarchy_Backup
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 |
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:
If an output window does exist, the progress can be observed.
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:
With the result returned
