According to the documentation here https://learn.microsoft.com/en-us/sql/relational-databases/databases/create-a-database-snapshot-transact-sql?view=sql-server-ver16 a database snapshot can’t be created directly, only through transact SQL.
The better option would be to create a backup as described here: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver16
and share this with someone to restore this on their system
Hi
Anyone who is interested with this question. I’ve achieved the result with following support answer:
Could you please clarify what you're trying to achieve? Move a snapshot of your built-in database to a SQL Server database? If so, you can do that using Studio Pro using the instructions in our documentation.
You should set the configuration to connect to the SQL database. You then have to add the source database settings to point to the built-in database:
No other settings required.
If you then start the application locally from Studio Pro, it will retrieve the data from the built-in database and copy it to the SQL Server. You should only do this once! Once the data has been copied from the HSQLDB database to the SQL database, you should delete (or at least, deactivate) the configuration to prevent the data in the SQL database being overwritten with the data from the built-in database again the next time you start the application from Studio Pro.