How I do to "migrate" the structure from aspnetdb.mdf to a mysql database

Question

I'm creating a new Asp.Net MVC 3 application. Visual Studio does a lot of the job of create the database and initial layout. Very nice! I will upload that initial files to my server, but I want that it runs using the MySql database on the server.

There's some quick/easy way to do it? I'm not worried about the data, just the structure of the tables, and the connection/configuration changes.

Thank you very much!

possible duplicate of How do I setup ASP.NET MVC 2 with MySQL? — Darin Dimitrov
– Darin Dimitrov, Commented Feb 2, 2011 at 19:49

Henk Holterman · Accepted Answer · 2011-02-02 19:47:07Z

1

You can export any MS-SQL database as a Script (Sql Server manager).
Fix it up to make it compatible.

But you will also need a Membership provider, look around if there exist any for MySql, otherwise you'll have to create one (movie).

answered Feb 2, 2011 at 19:47

Henk Holterman

276k33 gold badges353 silver badges540 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Seth · Accepted Answer · 2011-02-02 19:47:21Z

1

There are a number of tools listed in "Migrating from Microsoft SQL Server and Access to MySQL".

Or (assuming that you're using column types that exist on both platforms) you can write a script to convert a schema dump from SqlServer into MySQL (or do the conversion by hand in a text editor). Even better yet, you can write a program program to read the INFORMATION_SCHEMA table from SqlServer and produce the necessary CREATE TABLE... statements in mysql. Lots of options.

answered Feb 2, 2011 at 19:47

Seth

46.8k10 gold badges87 silver badges123 bronze badges

Collectives™ on Stack Overflow

How I do to "migrate" the structure from aspnetdb.mdf to a mysql database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related