CODEWITHSUNDEEP
mysqlsql-servermigration
sinthu225
sinthu225

Reputation: 311

mySQL to SQL Migration

I developed an application using PHP Laravel and MySQL. The database designed is not a good design. So I want to redesign the database in SQL with proper design and planning to do the project in C# ASP.NET. The problem is the developed application has more records in database. How can I achieve this by preserving the records.

Upvotes: 0

Views: 28

Answers (1)

Chris Travers
Chris Travers

Reputation: 26464

If you are redesigning your database structure there is no magic answer. However you can do it manually.

  1. Design your new system
  2. On paper, map fields from one system into another
  3. Write a script in any language that extracts the data from your system, transforms it, and loads it into the other system

Congrats! you have just completed your first major ETL project!

Note there are frameworks to help with this (called ETL frameworks). Whether they will help you with this is another question. You may want to look into this but you are more likely to find that your script takes less time to write than learning an ETL framework for a one-time use.

Upvotes: 1

Related Questions