MySQL database - General discussion

BugNET Forums

Forum General General discuss... MySQL database

11/8/2006 10:14 AM

	rdelgado
5 posts

MySQL database

Can i use MySQL database with BugNET. and if so does anyone have any installation material on how to connect with MySQL.

11/8/2006 1:03 PM

	admin
634 posts
bugnetproject.com

Re: MySQL database

Modified By admin on 11/8/2006 1:04:38 PM)

rdelgado wrote
Can i use MySQL database with BugNET. and if so does anyone have any installation material on how to connect with MySQL.

This would require a bit of work but should be possible. BugNET has been designed with a generic data access layer that can use any .net data provider. To get this working you need to:

Obtain a .net provider for mysql and put it in the BugNET bin directory.
Change the settings in the web.config to match the new dataproviders assembly name and types.

   <add key="assembly" value="System.Data" />
   <add key="connection" value="System.Data.SqlClient.SqlConnection" />
<add key="command" value="System.Data.SqlClient.SqlCommand" />
<add key="dataadapter" value="System.Data.SqlClient.SqlDataAdapter" />
<add key="parameter" value="System.Data.SqlClient.SqlParameter" />

      3. Convert the existing mssql scripts to make it compliant with mysql. I am not sure how hard this would be or if there is a tool to do this.

Currently the installation engine is hardcorded to the mssql client so you would have to run the converted scripts manually. This will be fixed eventually.

Edit

In 0.7 additional work would be needed to make the membership provider compliant with mysql.

Davin Dubeau
BugNET - Core Developer

11/9/2006 8:09 AM

	rdelgado
5 posts

Re: MySQL database

Thanks Davin i will give it a try. I am sure to have more questions as i attempt this.

11/13/2006 7:15 AM

	rdelgado
5 posts

Re: MySQL database

Hi. My situation is that i don't have MSSQL set up on my server so i don't need to convert any existing database i just need to be able to point it to MySQL. any other suggestions. What do you mean that i will need to run the converted scripts manaully??? how do i do that. I can't even complete the BugNET set up yet. Any addtional suggestions.

11/13/2006 7:53 AM

	admin
634 posts
bugnetproject.com

Re: MySQL database

rdelgado wrote
Hi. My situation is that i don't have MSSQL set up on my server so i don't need to convert any existing database i just need to be able to point it to MySQL. any other suggestions. What do you mean that i will need to run the converted scripts manaully??? how do i do that. I can't even complete the BugNET set up yet. Any addtional suggestions.

By running the scripts manually I mean that the installation engine of BugNET is hardcoded to use the MSSQL client library in .net so it will not work running the scripts against a MySQL database.

If you run them via mysql command line ... or a web admin interface like mysqladmin.

The other concern was that MSSQL (Transact SQL ) and MySQL have different types of sql, so you will need to manually go through the sql scripts and convert them as necessary.

I found this link which explains some of the differences in the script language.
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

Davin Dubeau
BugNET - Core Developer

Page 1 of 1

Forum

General

General discuss...

MySQL database

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.