This post will explain on 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 few existing tables of 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 have to use some third part tools, most commonly used ESF Database Migration Toolkit, this tool is free to use but it will append certain prefix/postfix to data.
After searching Google, what I found is that On August 12, 2010, Microsoft made available the first version of a tool designed to help customers migrate from MySQL to SQL Server and/or SQL Azure.
The MySQL migration tool is part of the SQL Server Migration Assistant (SSMA) tookit family. Microsoft delivers database migration tool for Oracle to MSSQL, SYBASE to MSSQL, MySql to MSSQL and MS Access to MSSQL.
In our case it is MySql to MSSQL.
1. Dowbload the Microsoft SQL Server Migration Assistant for MySQL from Microsoft SQL Server Migration Assistant for MySQL v5.2
2. We also need to download the Standardized database driver Windows, Linux, Mac OS X, and Unix platforms.
Once you have downloaded and installed both of them,now launch the SSMA tool.
This tool can do wonders. It allows to migrate the schema or you can select certain tables, and same goes to data migration for whole scheme or certain tables. It generate the reports before performing the migration and tells you the summary that what it can migrate and what it can't migrate and also post migration reports telling us that how well the migration was. Below is the screen shot of the tool.
|
|---|
Now, how to use this tool to perform the migration, is pretty easy and step by step process, you can watch the videos:
Converting and Migration is pretty well explains in the videos, just follows the steps and you will have it done as I got it working very well. I managed to migrate my existing application schema and data without a single error over to MSSQL and have the application up and running.
I hope this will help.