...
1. To run joget on MSSQL 2005, you can refer to this post : Running on Microsoft Configure for MS SQL Server 2005
2. Once you have it running, import your existing joget application.
...
This tool can do wonders. It allows to migrate the schema, or you can select certain tables. The same goes for data migration for whole scheme or certain tables. It generates the reports before performing the migration and tells you the summary for what it can migrate and what it can't migrate, and also post migration reports telling us how well the migration went. Below is the screenshot of the tool.
|
|---|
Now, how to use this tool to perform the migration is an easy step-by-step process. You can watch the videos here:
Conversion and migration are pretty well explained in the videos. Just follow the steps; you'll be able to do it. I got it working very well and managed to migrate my existing application schema and data to MSSQL without a single error, and I had the application up and running.
I hope this helps.