0

Possible Duplicate:
How to migrate MSSQL database to MySQL?

there is a asp.net 4.0 project that i'm working on, database:Mssql i generated all the procedures , data access layers, and business layers using ignyter software, now i have a requirement that i am forced to convert the same project to mysql..

What are my options? are there any tools that convert all my tables and proedures to mysql,.. and also my business and data access layers..

Any opinions or options would be really great, i hate to redo all my work again..

Community
  • 1
  • 1
user1666443
  • 19
  • 4
  • You may have just learned a lesson on why you should think twice about putting too much application logic into a database. You now have your application tightly coupled with your data store. – Mike Brant Dec 21 '12 at 17:15
  • There is nothing that is automated and will get things 100% correct. Some expressions in one SQL language variant just don't exist in others. As an aside, why MySQL? Why not something like PostgreSQL? (Does the person who made this decision realize that the MySQL client driver is GPL, and that this will likely "infect" your product, unless your company purchases a license?) – cdhowie Dec 21 '12 at 17:15
  • thanks brant.. what are my options now?? – user1666443 Dec 21 '12 at 17:21
  • cdhowie .. thanks for your reply.. but we do have a licence. – user1666443 Dec 21 '12 at 17:23

1 Answers1

0

I do recommend for generating database script your MSSQL database and loading slowly fences in MYSQL. To use MySQL with your project asp.Net uses this connector: MYSQL CON.

I used it and it has worked well. I hope you work.

Shortys Oberto Dutari
  • 558
  • 6
  • 17