| Author |
Topic |
|
fogcreek
Starting Member
3 Posts |
 Posted - 2006-10-19 : 17:56:00
|
| Our customers use MS SQL or MySQL as the database to hold the data from our application. When they have to move from MS SQL to MySQL for whatever reason, we generally recommend the mssql2mysql converter tool by Michael Kofler.Do any of you have experience with the MSSQL2MySQL converter for turning a SQL Server db into a MySQL db?http://www.kofler.cc/mysql/mssql2mysql.htmlMSSQL2MySQLSpecifically, some of our customers have multilingual data in their SQL Server databases; is it known for turning multibyte charset data into mush?By the way, there is a similarly named converter, MSSQL-to-MySQL, that's not so hot with multibyte charsets.http://www.convert-in.com/mss2sql.htmMSSQL-to-MySQLVladimir Bilyak, a representative from Intelligent Converters, said: "It looks like your Russian text is encoded using multi-byte char set. Our products doesn't support multi-byte code pages like Unicode. Only 1-byte char sets are supported. We are planning to implement this feature in one of next releases."Much thanks. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-10-20 : 05:58:03
|
| Sorry but I can't help....(it's great NOT working in the unicode environement!!...I keep missing out on these headaches!!)But I would like to comment and welcome a (purported) representative from the great "JoelOnSoftware" team to SQLTeam.com. Mind you if you guys are having a problem....then it's on the bleeding edge. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-21 : 10:52:36
|
| I think your best bet (however, I'm only guessing!) would be to export the data from MSSQL to files, in Unicode format, and then find something that can preserve the characters during import into MySQL (about which I have NO knowledge!)BCP (and probably DTS too) can make the Export from MSSQL for you."the great "JoelOnSoftware""+1 to that!Kristen |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-10-21 : 14:03:07
|
quote:
When they have to move from MS SQL to MySQL for whatever reason
and what reasons could that be?-- Alice came to a fork in the road. "Which road do I take?" she asked. "Where do you want to go?" responded the Cheshire cat. "I don't know," Alice answered. "Then," said the cat, "it doesn't matter." |
|
|
|
fogcreek
Starting Member
3 Posts |
Posted - 2006-10-23 : 12:11:28
|
| You're so kind! Thanks for the welcome, and glad y'all enjoy Joel's blog.PSamsig, sometimes customers are switching to an all-Unix shop, and sometimes they're standardizing on MySQL on Windows. I'm sure there are other reasons but those are the ones I hear more often.Kristen, thanks for the note. Yeah, I hear good things about DTS and BCP for exporting or importing wrt SQL Server, but the other half of the problem -- the MySQL half -- is stickier. Maybe we should find a good MySQL import-from-files tool that preserves Unicode, and just advise people to use that two-step process if they have to migrate multibyte charset data. I'd prefer to be able to recommend an all-in-one tool, but if no suitable one exists....Sumana |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-23 : 14:47:00
|
| "I'd prefer to be able to recommend an all-in-one tool"I wonder if you can DTS direct from MSSQL to MySQL? In theory, with a decent MySQL ODBC/OLE-DB/WhatEver! driver this should be a no-brainer, but I'm afarid I don't know enough about MySQL to know if this is a runner, or not.Kristen |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2006-10-23 : 16:03:14
|
| >> I wonder if you can DTS direct from MSSQL to MySQL?Yes you can... (ODBC driver)Perhaps you should try the equivalent of mysqldump...Export the SQL Server data as SQL statements....DavidMProduction is just another testing cycle |
|
|
|
Kristen
Test
22859 Posts |
|
|
wonn1377
Starting Member
3 Posts |
Posted - 2009-08-27 : 05:29:01
|
quote:
Originally posted by PSamsig
quote:
When they have to move from MS SQL to MySQL for whatever reason
and what reasons could that be?-- Alice came to a fork in the road. "Which road do I take?" she asked. "Where do you want to go?" responded the Cheshire cat. "I don't know," Alice answered. "Then," said the cat, "it doesn't matter."
I use data loader for migrating almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. In my view this is a best Data Migration Tool Download Free : http://www.convert-db.com/mssql-to-mysql.htm |
|
|
|
|
Converting multilanguage DBs from MS SQL to MySQL