Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AspDotNetStoreFront
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Webhost4Life - $4.95 Windows Hosting
 


  Sponsors  

Meet Our Sponsors

DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Chat About It!  MySQL 5x and DotNetNuke 4.7x
Previous Previous
 
Next Next
New Post 4/28/2008 6:58 AM
User is offline Al Williams
55 posts
www.sunsethill.ca
10th Ranked




MySQL 5x and DotNetNuke 4.7x 
Modified By Al Williams  on 4/28/2008 10:00:12 AM)

Hello,

I've read through many of the threads related to using MySQL with DotNetNuke.  I've spent a fair amount of time working with MySQL recently for a non-DNN related work engagement for a client.

I'm extremely impressed wity MySQL (version 5x) - and would like to hear from anyone out there who is using MySQL with DNN.  I'd basically like to know how you got it to work... For example, did you convert the core SP's to MySQL procedures?   Are you purchasing and conveting commercial 3'rd party modules to work with MySQL?

I see that there are some pretty impressive looking applications that claim to convert complete MSSQL Server databases to MySQL - including all the objects - and data...  Has anyone used any of these products - or were you able to use the MySQL Migration Toolkit?

Thanks in advance, Al

 
New Post 4/28/2008 7:48 AM
User is offline Sebastian Leupold
14288 posts
www.deutschnetnuke.de
1st Ranked












Re: MySQL 5x and DotNetNuke 4.7x 

Al,

to use DNN with another Database server you need to adopt all install scripts and create custom data providers for the core framework and all module - due to the effort needed, there is (AFAIK) only one company providing an additional data provider (for Oracle), any other attempts have failed.

The conversion tools you mentioned will not be of great help, because they simply transfer databases from one server to another but do not adopt the code to access the database nor create adopted SQL scripts for generation or upgrade, which can be installed as a package.

Depending on the options of announced "Linq to Entities", this possibly might provide an option for DNN in the future, to become more DB agnostic and allow for an easy change, but this will require a lot of code modifications and investigations by the core team and weigthing pro and cons and I would not expect any solution within the next year.


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 4/28/2008 8:12 AM
User is offline Al Williams
55 posts
www.sunsethill.ca
10th Ranked




Re: MySQL 5x and DotNetNuke 4.7x 

Hi,

I fully understand that support for MySQL is not part of the DNN core - and won't be anytime soon - for all the reasons you mentioned. 

What I'd like to determine is if anyone actually has a production DNN portal working with MySQL 5x.... and if there is - I'd be interested in how you were able to make this work.

Thanks in advance, Al

 
New Post 4/28/2008 11:48 AM
User is offline Jeff Cochran
1391 posts
6th Ranked


Re: MySQL 5x and DotNetNuke 4.7x 

I don't think anyone is using MySQL with current DNN versions, at least nobody has announced a provider for the MySQL database.  I think the major driving force behind MySQL being used is now gone, most hosts are providing ASP.NET plans with SQL Server at no extra charge.  Cost was the only overwhelming reason to use MySQL, and version 5.0 of MySQL still doesn't provide any advantages over SQL Server.

Jeff

 
New Post 4/28/2008 2:33 PM
User is offline Al Williams
55 posts
www.sunsethill.ca
10th Ranked




Re: MySQL 5x and DotNetNuke 4.7x 

Jeff,

I agree that for most hosting providers - cost is not the issue it used to be with using SQL Server.  I also agree that MySQL doesn't provide any advantages over SQL Server - but I have to say it is a very, very impressive Open Source application.  I didn't know much about MySQL (other than the fact that it existed)  until a few months ago when I had an opportunity to do a job for a company that has leveraged many of their apps with MySQL.

I just posed the question here because I wanted to see if anyone actually is using a current version of DNN with MySQL.  I guess we'll see if anyone steps forward...

Al

 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Chat About It!  MySQL 5x and DotNetNuke 4.7x
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Swirlhost Inc.
Affordable DotNetNuke Hosting, Skin Development, Custom Module Development, and DotNetNuke Consulting. We will install your preference of DNN and now host with us and get a free license for the Swirl AJAX Chatroom Module.
www.swirlhost.com
Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com
DNNCovered.com - Your Offshore Dotnetnuke Partner
Dnncovered.com is the only Dotnetnuke offshore outsourcing center specializes in DNN skinning and module development with lowest pricing and quality service. Our staff is dedicated to websites based on DNN and our graphic designers are creative and imaginative well enough to provide customers the complete set of skinning solutions and packages
www.dnncovered.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP