MYSQL data into MS SQL 2008 Express?
|
apostre
Joined: 2006-12-14
Posts: 4 |
Posted: Fri, 2009-04-17 19:35
|
|
is it possible to move the data from an mysql DB to a ms sql 2008 express db? anyone done this? |
|
Posts: 215
Its possible. I've done it to 2005. Its easier if you have something which has DTS\SSIS on it to transfer the data for you. I used the developer edition of MSSQL at work to do this as it has\had better tools than Express.
Whatever you do, make sure you have a complete backup of both the db and the g2data which you can restore to the point before you start the conversion.
Steps I took were:
1. Install G2 with Exactly the same plugins and versions as you had on the MySQL installation, but on MSSQL. This should get the table structure across.
2. Delete all rows from ALL tables
3. Use DTS\SSIS to transfer the data from Mysql into the MSSQL tables *** You probably can use another mechanism to do this.
4. Change config.php in one of the two galleries so that it points to both the g2data folder and the MSSQL db.
5. Test that everything works. (Some things may not have been developed\tested on MSSQL).
Ideally For Step 4 you would replace the g2data of the MSSQL installation with a complete clone of the MySQL g2data so that you can go back to mysql if there is a problem.
Looking forward G3 is not likely to be supporting MSSQL (at least in the short term, although someone else may port it to MSSQL) so using MSSQL may be leaving you in an awkward upgrade situation.
_________
Mark