BugNet and MySql - General development

BugNET Forums

Forum Development General develop... BugNet and MySql

6/21/2007 8:39 AM

	ChrisMan
22 posts

BugNet and MySql

Hello David,

Is there any plan to run BugNet on MySQL? I've just seen that the MySql's Connector.Net assembly provides a MySQLMembershipProvider, so there would be "only"/mainly the BugNet_XXX stored procedures and tables to migrate... (I may try to begin the work if nobody has worked on it).

Cheers,

Chris

6/21/2007 9:47 AM

	ChrisMan
22 posts

Re: BugNet and MySql

David,

I began to have a look to your SQL. Is that normal that sometimes you use @@IDENTITY and sometimes SCOPE_IDENTITY() ? HAving a look at the queries, I was wondering if that was something needed and/or desired.

Chhers,

Chris

6/21/2007 4:35 PM

	admin
658 posts
bugnetproject.com

Re: BugNet and MySql

ChrisMan wrote

Hello David,

Is there any plan to run BugNet on MySQL? I've just seen that the MySql's Connector.Net assembly provides a MySQLMembershipProvider, so there would be "only"/mainly the BugNet_XXX stored procedures and tables to migrate... (I may try to begin the work if nobody has worked on it).

Cheers,

Chris

There is no plan at this time to support another database (although as you know it is possible). This would be a welcome addition and I am sure you would have a few people eager to have this.

Davin Dubeau
BugNET - Core Developer

6/21/2007 4:36 PM

	admin
658 posts
bugnetproject.com

Re: BugNet and MySql

ChrisMan wrote

David,

I began to have a look to your SQL. Is that normal that sometimes you use @@IDENTITY and sometimes SCOPE_IDENTITY() ? HAving a look at the queries, I was wondering if that was something needed and/or desired.

Chhers,

Chris

This needs to be updated ..they should all be SCOPE_IDENTITY() calls. Thanks for noticing this.

Davin Dubeau
BugNET - Core Developer

Page 1 of 1

Forum

Development

General develop...

BugNet and MySql

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.