select from msql and insert into mysql [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, 开发者_如何学Pythonor rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago.

hi i want to create my database on mysql which is already exists on mssql i want to select data from mssql and insert this into mysql database is there any query to do this plz tell me is this possible

---

I currently use ssis to do this I have a db in MSSQL and a remote one in MYSQL create a connection to both then transform the data from one to the other.

---

There exists software that allows you copy/transfer data from one database to another. Talend, for example.