This post will explain how to run joget on MSSQL and migrate the existing schema and data from mysql to mssql 2005, in step-by-step manner.
1. To run joget on MSSQL 2005, you can refer to this post : Running on Microsoft SQL Server 2005
2. Once you have it running, import your existing joget application.
Till this point, all is pretty much straightforward. Now the issue arises on how to import the existing schema and existing data from mysql to mssql 2005. Here, I am referring to a few existing tables of in my joget application and the data which I would like to migrate to MSSQL and have it running properly, without any errors.
To do the migration, We we have to use some third party tools, the most commonly used of which is the ESF Database Migration Toolkit. This tool is free to use, but it will append certain prefix/postfix to data.
...
This tool can do wonders. It allows to migrate the schema, or you can select certain tables. The same goes to 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.
...
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.
...