How can I assign a MS SQL-based XpertIvySystemDataBase as the Designer's SystemDb

Dear Reguel (is it ok?)

Is there no possibility to store the content of the Hypersonic MEMORY Database for developing and testing functions like ITask, TaskQuery etc.? Now I must create every day new cases and tasks in the Designer.

Best regards Dieter

Dear Sir,

thank you for your answer. Sorry, where can I found the Export-SQL-Script? There was no attachment to the e-mail or our virus detection has deleted it.

Best regards Dieter Staudt

Reguel is ok :)

the export script will be written to the path you specify as parameter. In the example above the file c:/temp/myHsqlDbExport.sql will be written when the command is executed...

Dear Reguel, thank you. the first step works fine - I have all "my" case- and task-data etc. No I must try to restore this sql-file.

Dear Reguel,sorry. It's me again. All tries restoring the saved database don't work.

1. DROP... and COPY the complete saved file into the db window the error message "invalid schema name in statement (CRATE SCHEMA PUBLIC AUTHORIZATION DBA ) apperas.
2. Only COPY of all INSERT statements: following error message "violation of unique constraint SYS_PK_48: duplicate value(s) for column(s) ... of the first table form the instert statements" appears.
3. and DELETE and INSERT do not work because there are problems with missing forreign keys and so on. Do you have any idea? Best regards Dieter

I'd try to work with a delta insert.

1. Start a Designer with an empty workspace
2. Export the SystemDb at the current state
3. Import your project and start the engine
4. Create your tasks that you wan't to re-use
5. Export the SystemDB again
6. Work with a diff tool like WinMerge or similar to find the differences between the first and the second DB export. Try to only apply these insert statements which we're added by your engine start + task creations after a re-boot of the engine