Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
copeleto
Starting Member
5 Posts |
 Posted - 2005-05-11 : 19:34:49
|
| Hi,I have a db in mysql but i want to migrate the data to mssql sever, how can I do that?...I can not find any tools in mysql to export the data.Thanks a lot |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-05-11 : 20:03:46
|
| use the mysqldump utility.go to www.mysql.org and read the documentation on how the tool works.You will have to manually edit the file to fix some of the syntax differences, but it should be pretty straightforward.Another approach you can take is to use DTS from the SQL Server side. You will need to have the mysql odbc drivers installed in order for that to work.-ec |
 |
|
|
mateamargo
Starting Member
10 Posts |
Posted - 2005-06-10 : 11:09:55
|
| Or you can use MyODBC to connect MySQL database and use it into a DTS package:http://dev.mysql.com/downloads/connector/odbc/3.51.html |
|
|
|
|
|
|
migrate from mysql to mssql server