0

My client has a large MySQL database with about 5GB of data (15M records). They want to migrate to SQL Server 2008 R2.

What is the best Approach to Migrate from MySQL to SQL server on Live Environment?

surfmuggle
  • 5,527
  • 7
  • 48
  • 77
Mohamed Mahyoub
  • 381
  • 2
  • 18

1 Answers1

0

We have migrated the MYSQL Database with 1Gb of data previously .

We have used the Microsoft SQL Server Migration Assistant v5.3 for MySQL tool for this activity.

It is very helpful in migrating huge databases.

you can download it from downloadLink .

Step by step guide is mentioned in video Step by step guide video

You should also change the jdbc drivers and the Database connection URLS on production

Shirishkumar Bari
  • 2,692
  • 1
  • 28
  • 36