Hello,
We are currently using a Mysql database: we would like to change. Now, we'd like to use Mssql. Only problem is that most of the data and other information are on Mysql. Can you help us with this?
Thanks a lot for your help.
asmikwen
0
Newbie Poster
Recommended Answers
Jump to Postyou can import the data, in management studio right click on your destination database and click import, then set up a mysql connection to your other database
depending upon how mysql specific the queries are, they could most likely be used as well, just swapping out the connection strings
All 2 Replies
dickersonka
104
Veteran Poster
you can import the data, in management studio right click on your destination database and click import, then set up a mysql connection to your other database
depending upon how mysql specific the queries are, they could most likely be used as well, just swapping out the connection strings
bgkalbente
0
Newbie Poster
As I read on your post, you are needing to get data to your other database. You could try using some software that will help you in managing the transfer.
I can recommend the use of data integration software such as Datastage (licensed program) or Talend Open Studio (Talend is open source). Tell us how it went.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.