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  |  

AppTheory specializes in solutions based on the DotNetNuke platform and has 2 employees on the DotNetNuke Core Team.
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

Click here to go to dev.live.com for Windows Live developer resources
SteadyRain
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.
 


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
14293 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.

 


TMA Resources
TMA Resources is a software company providing eBusiness solutions for the Association market.
www.tmaresources.com
DotNetNuke Hosting Provider UK
UK leading DotNetNuke Hosting provider. Owned and operated by a Microsoft Gold Certified Partner.
www.DNN-Portals.co.uk
Alliance Systems & Programming Inc
Alliance is not just our name... it's how we do business. We partner with our clients, learning their business processes and standards and then applying our expertise to help them improve their workflow and profitability.
www.Alliancesys.com

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