CODEWITHSUNDEEP
mysqlsql-servermigrationdatabase-migration
burakim
burakim

Reputation: 482

MSSQL and MYSQL Migration

I have migration problem that must be resolved at ten days. I have middle sized c# web server that has 50.000 line of code and also I have middle sized SQL Server that has triggers, storage procedures and 20 tables that contains at least 10 columns.

Because our Microsoft licences will be expired end of this month, we must convert project to project that uses mysql database for reducing our cost of server without buying Microsoft SQL Server licence. I cannot change adapter class simply because I did not wrote c# server code. If I want to make any changes on server program, I must understand whole project and I takes at least 2 weeks because of tons of codes.

What you advise me about migration process? I need quick and robust migration tactic. I cannot take backup because my server data exceeded 10TB data (yeah bad programming).

Thanks for advising.

Upvotes: 3

Views: 160

Answers (1)

Ryszard Bocian
Ryszard Bocian

Reputation: 111

Migration of stored code (procedures, triggers) would be challenging task. Please read this guide: https://www.mysql.com/why-mysql/white-papers/guide-to-migrating-from-sql-server-to-mysql/

I don't think that migration without changing c# code would be possible.

Upvotes: 1

Related Questions