MSSQL-to-MySQL Migration Script?

702 views
Skip to first unread message

Matt Quackenbush

unread,
Dec 11, 2011, 9:09:47 PM12/11/11
to blo...@googlegroups.com
After being steadfastly in the SQL Server camp for the last 15+ years, I have finally seen the light and am in the process of moving all of my stuff to MySQL.  In doing so, I've searched the interwebs (and this list) but have not yet come across a migration script to move BlogCFC from an SQL Server database to an MySQL database. Does such a thing exist?  (I'm hoping that someone else has gone down that road before me.)

Thanks!


Raymond Camden

unread,
Dec 11, 2011, 10:48:04 PM12/11/11
to blo...@googlegroups.com
I don't store data in any way that is db specific - so in theory, any
migration tool should handle it.

--
===========================================================================
Raymond Camden, Adobe Developer Evangelist

Email : raymon...@gmail.com
Blog : www.coldfusionjedi.com
Twitter: cfjedimaster

MichaelEvangelista

unread,
Dec 11, 2011, 11:53:09 PM12/11/11
to BlogCFC
Hey Matt - have you used Navicat?
It is a great mySQL tool with tons of import options, including MS SQL
ODBC connection.

http://navicat.com/en/products/navicat_mysql/mysql_overview.html - I
use it almost daily,
pretty sure they still have a full featured free trial.

Jason Dean

unread,
Dec 12, 2011, 12:05:00 AM12/12/11
to blo...@googlegroups.com
I have used AquaData Studio for DB migrations. I have also used EMS SQL Manager with success for migration. 

Akbarsait

unread,
Dec 29, 2011, 9:48:22 PM12/29/11
to BlogCFC
I recently migrated my blog from MSSQL to MySQL using the MySQL
Migration toolkit and its worked like a charm.

http://dev.mysql.com/downloads/gui-tools/5.0.html

Thanks,
Akbar
www.akbarsait.com

On Dec 12, 10:05 am, Jason Dean <deanj...@gmail.com> wrote:
> I have used AquaData Studio for DB migrations. I have also used EMS SQL
> Manager with success for migration.
>
> http://www.aquafold.com/http://www.sqlmanager.net/
>
> Jason
>
> On Sun, Dec 11, 2011 at 10:53 PM, MichaelEvangelista <gowest...@gmail.com>wrote:
>
>
>
>
>
>
>
> > Hey Matt - have you used Navicat?
> > It is a great mySQL tool with tons of import options, including MS SQL
> > ODBC connection.
>
> >http://navicat.com/en/products/navicat_mysql/mysql_overview.html- I
Reply all
Reply to author
Forward
0 new messages