Self-Introduction: Michael Thomas

[Michael Thomas]

    *  Michael Thomas

    * Westlake, CA United States
    * Systems Administrator (sometimes developer)
    * ValueClick, Inc
    * MSSQL Support for Bugzilla
    * Historical qualifications
          o Various internal web and desktop applications
          o Perl, PHP, C#, VB.NET, ASP.NET so on so forth.
          o MSSQL/MySQL
          o Expert Windows OS

I'd like to pick up Issue 285122
https://bugzilla.mozilla.org/show_bug.cgi?id=285122

I have successfully gotten Bugzilla to work with MSSQL to the point that basic operations are working.

DB modules for all platforms will need to be tweaked a bit, the primary things of concern\interest is the support for datetime operations as they seem to be the biggest blockers.

Example areas to work on are, as they don't exist in MSSQL:
DATE_FORMAT
NOW
INTERVAL
REGEXP

Others but limited to are:
INSTR
LIMIT
FK (Multi Path CASCADE is not allowed on UPDATE or DELETE in MSSQL, triggers are best practice for MSSQL.

Most or all functionality can be replicated in user-defined function and store procedures, triggers. Perl side, existing calls need to be moved into the DB modules and out of the hard coded strings to allow for variance in the calls depending on the db.




This email and any files included with it may contain privileged,
proprietary and/or confidential information that is for the sole use
of the intended recipient(s).  Any disclosure, copying, distribution,
posting, or use of the information contained in or attached to this
email is prohibited unless permitted by the sender.  If you have
received this email in error, please immediately notify the sender
via return email, telephone, or fax and destroy this original transmission
and its included files without reading or saving it in any manner.
Thank you.