Hello.
I have created a web site using visual web developer (free download) The website was created using asp.net 2.0. The vwd I have incorporated the cool new roles and membership features of asp.net 2.0. When i did this vwd automatically created a sql express database (aspnetdb.mdf) to hold the login stuff.
I then purchased som e web hosting from a company and found out that they only support MySQL databases.
My questions are;
1. Can anyone tell me the difference between the two types of database (i know what sql express is but am not sure what MySQL is)
2. Secondly, is there a tool or way I can convert the SQL Express database to a MySQL database
TIA
ICW
Convert a sql express to mysql
Shawn_CEO
First, the MySQL Commuity Edition is free to use, for any purpose, even commercially. You cannot, however, modify the Community Edition and redistribute those changes without distributing source code.
Now, there is the MySQL Enterprise Edition, which has some additional features and is supported by MySQL AB (the Community Edition is on an "as is" basis - MySQL AB is under no obligation to offer any support whatsoever). If the web hosting company is using MySQL Enterprise edition, then they may or may not be violating the terms of their contract with MySQL AB.
MySQL supports stored procedures as of version 5. Note that stored procedures, along with many other features, are only supported on the InnoDB engine. The InnoDB engine is a much better choice than the MyISAM engine, but unfortunately many web hosts set MyISAM as the default because it requires less disk space and is less memory intensive.
Note that MySQL is not the right choice for every situation. I am currently migrating to SQL Server Express, primarily because it integrates better with ASP.net.
laszlo.gosztola
Thanks
The SQL Express database does indeed have several stored procs "aspnet_membership...". are you saying that MySQL cannot do stored procedures
Regards
ICW
Jean St-Arneault
MySQL is a rather poor database that lots of people use illegally because they think it's free. If the web hosting company is charging you for hosting, they are using MySQL commercially and either paying for it or breaking the law.
Odds are that the SQL Server database is using stored procs, if this is so, then possibly not. If it's just using tables and dynamic queries, then probably.
Sean2408
Yes, MySQL does have stored procedures. It didn't use to (pre version 5.0) but it does now. Please see this link for a write-up: http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
If the hosting company you have chosen is using anything before MySQL 5.0 then stored procedures are out of the question. Also, if the stored procedures are using T-SQL specific constructs then you may have to find their equivalents (if they exist) in MySQL. For example, if you use X() in SQL Server the equivalent may be Y() in MySQL and so when you code your MySQL stored procedure you use Y().
However, if your stored procedures are doing something fancy then chances are you won't find a MySQL equivalent (although MySQL is faithful to all the standard SQL constructs for the most part so if you only use standard SQL then there's a chance there that you can migrate (reasonably) painlessly).
I have never had the experience of doing a SQL Server --> MySQL conversion, but here is a page that may help you:
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
A quick browse shows it references a few tools that you might use and also has links to forums and other places where people (like MySQL experts) could offer some good advice.
Sorry I can't be of more help at the mo.
Jennifer Huang
Hi everyone
I too have been struggling to deploy the ASPNETDB database on alternative platforms. From many hours of reading MS documentation it seems that the only answer is to create your own Membership and Role providers that conform to the published API of ASP.NET This means writing a lot of code but it can be done. You also have to tell your application to use your version rather than the default one by altering the settings in the web.config file.
It seems that Microsoft left the door open for this and publish guidance to that effect. It's not a question of converting the tables etc, you can't do it! Its a matter of providing an interface between the objects built-in to the Framework class library and your own database engine and data files.
Now the real question is has anyone out there done this for MySql Is there a software company selling addons to support it
Regards
Phil Hall
Mrishi
Thanks for your help
regards
ICW