https://answers.axonivy.com/questions/2009/how-can-i-assign-a-ms-sql-based-xpertivysystemdatabase-as-the-designer-s-systemdb<p>Hello together,</p> <p>in my Designer environment all cases, tasks etc. will only be available through the actual session; after close/reopen the Designer all this informations are lost und for example the TaskQuery will not work. </p> <p>In the meantime I defined the SystemDb as a Hypersonic SQL DB in the Memory (like Q&amp;A#996) but all the informations are also lost after restart the Designer.</p> <p>Is there a way to assign a MS SQL-based XpertIvySystemDataBase as the Designer's SystemDb or to save the Hypersonic MemoryDb to MS-SQL to store all the contents permanently for further developing and testing?</p> <p>Thanks in advance.</p> <p>Dieter </p>enThu, 08 Sep 2016 14:57:01 -0400https://answers.axonivy.com/questions/2009/how-can-i-assign-a-ms-sql-based-xpertivysystemdatabase-as-the-designer-s-systemdb/2012<p>Create a Database Configuration:</p> <ul> <li>database = Hypersonic SQL Db</li> <li>driver = HSQL Db Memory</li> <li>DatabaseName = AxonIvySystemDatabase</li> </ul> <p>Open the SQL query window and execute:</p> <ol> <li><code>SCRIPT 'c:/temp/myHsqlDbExport.sql'</code> to export the full system db schema plus its content</li> <li><code>DROP SCHEMA PUBLIC CASCADE</code> removes the default system db after a restart</li> <li>Paste the content of the previously exported SQL file to re-create the old version</li> </ol> <p>Normally you will run into escaping and encoding problems in the last step. A practical solution could be that you only re-import the INSERT statements instead of the whole SCHEMA+DATA to avoid these problems.</p>Reguel WermelingerThu, 08 Sep 2016 14:57:01 -0400https://answers.axonivy.com/questions/2009/how-can-i-assign-a-ms-sql-based-xpertivysystemdatabase-as-the-designer-s-systemdb/2012https://answers.axonivy.com/questions/2009/how-can-i-assign-a-ms-sql-based-xpertivysystemdatabase-as-the-designer-s-systemdb/2010<p>You can setup a standalone DB (like MsSql) with an Axon.ivy Engine Configuration UI. To run this DB in a Designer simply copy the <code>/configuration/serverconfig.xml</code> of the engine into your designer. With this approach you will need a license as well for the designer. </p>Reguel WermelingerWed, 07 Sep 2016 12:47:43 -0400https://answers.axonivy.com/questions/2009/how-can-i-assign-a-ms-sql-based-xpertivysystemdatabase-as-the-designer-s-systemdb/2010