Member Avatar for asmikwen

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.

  • 3 Contributors
  • 2 Replies
  • 76 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by bgkalbente
Member Avatar for dickersonka

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

Member Avatar for bgkalbente

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.