Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Migrating from MSSQL to MySQL?

Good morning, I have a project that's built on MSSQL/ASPsince, my client wants to upgrade the platform to be on PHP/MySQL, what's the simplest way to bridge (not just migrate) or replicate the data between MSSQL and MySQL, since MSSQL is feeding several platforms that will stay active and PHP MSSQL is a bit slow and have several limitation I will have to use both.

user-image
Question ajoutée par Shady Sahyoun , Online Editor and Database , Degrees S.A.R.L Beiru
Date de publication: 2016/03/09
Shady Sahyoun
par Shady Sahyoun , Online Editor and Database , Degrees S.A.R.L Beiru

That's an important question! I have done it once and it ain't that simple... I will guide you through step by step!

Check your server for the MSSQL plugins, they are available on microsoft for each php version you're using there is a plugin,

Create MySQL db and keep in mind that Chars, Arabic and the length of the data needs to be set on both databases correctly or they will be read in an unacceptable way.

create a script that reads from SQL to MySQL and set it in cron (to run automatically on specific times) or if the server is ISS the scheduler rather than cron job. (if you need a sample of the script message me it was a huge work to find the right context)

Good luck

Mohammad Reaz  Uddin
par Mohammad Reaz Uddin , Senior Software Engineer , Logic Software Ltd

To migrating MSSQL to MySql you follow some spats...........

  • Take care of Prerequisites
  • Select Source and Target Database
  • Migrate the Objects
  • Data Migration

 

 

 

 

More Questions Like This