...
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 in my joget application and the data which I would like to migrate to MSSQL and have 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.
...