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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 MSSQL to MYSQL on another server

Author  Topic 

sterckx
Starting Member

1 Post

Posted - 2010-08-20 : 08:19:10
Locally we're using Microsft CRM that uses MS SQL. We're using that data for the content on our website ( also locally ) Now we going to host our website ( Combell, with drupal and an MYSQL DB)

How can we get the data from our MSSQL DB to MYSQL? We're testing a program (dbconvert.com) on our server to convert the mssql to mysql (local)

How can we get the data in the mysql of our hosting partner?

Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-08-24 : 05:23:54
1 Use Import/Export wizard
2 If the direct connectivity is not possible, export data from SQL Server to text files, and import them to MySQL database

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -