Migrating MySQL to Sql Server,

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Migrating MySQL to Sql Server,

Jason Farmer

Hi,

 

My boss has set me the task of implementing Bugzilla on our Windows 2003 server using SQL server DB, I don’t know if he has researched the implications, so I am assuming not. I am confident that I could get Bugzilla up in its own right, but could anyone explain roughly if this is possible and what’s involved in achieving this?

 

If anyone could share any experience in this area I would be grateful

 

Regards,

 

Jason Farmer

Tel: 0870 600 5656

[hidden email]

Crimson Limited <a href="file:///C:\Documents%20and%20Settings\Jason.Farmer\Application%20Data\Microsoft\Signatures\www.crimson.co.uk">www.crimson.co.uk

This email and any files transmitted with it are confidential and it may be privileged. It is intended solely for the use of the individual or entity to whom it is addressed. The views expressed may not be official policy, but the personal views of the originator.

Whilst Crimson Limited and the sender have taken every precaution to prevent transmission of computer viruses, should this inadvertently occur we do not accept any liability. Please check for viruses before accessing attachments.

If you have received this in error, please do not use, disclose, distribute, copy, print or rely on this email - contact the sender and delete the material immediately.

 

Reply | Threaded
Open this post in threaded view
|

Re: Migrating MySQL to Sql Server,

Trent Ohannessian
I just got Bugzilla set up and running on a DB2 ver. 8.1.5 with minimal
problems.  I had done this previously but took a different approach this
time around.  Previously I ran checksetup.pl and created all of the
databases in a MySQL database, and then converted that over to DB2.
This time around I started from checksetup.pl and ran that against DB2.
  Overall it was a pretty painless process.  It was slow going at some
points as a single change is made and you have to wipe out the database
and start from scratch.  I just had to make sure I or someone ran
through the entire application to exercise all of the SQL code in search
of incompatibilities.  The biggest hitch you'll probably see is the
syntax itself.  MySQL has some nice features that don't translate into
other databases, and if they do they are handled in vastly different
ways.  It's a good project and I hate to say it but it was kinda
enjoyable. :)

Trent

Jason Farmer wrote:

> Hi,
>
>  
>
> My boss has set me the task of implementing Bugzilla on our Windows 2003
> server using SQL server DB, I don’t know if he has researched the
> implications, so I am assuming not. I am confident that I could get
> Bugzilla up in its own right, but could anyone explain roughly if this
> is possible and what’s involved in achieving this?
>
>  
>
> If anyone could share any experience in this area I would be grateful
>
>  
>
> Regards,
>
>  
>
> Jason Farmer
>
> Tel: 0870 600 5656
>
> [hidden email]
>
> Crimson Limited www.crimson.co.uk
> <file:///C:\Documents%20and%20Settings\Jason.Farmer\Application%20Data\Microsoft\Signatures\www.crimson.co.uk>
>
> This email and any files transmitted with it are confidential and it may
> be privileged. It is intended solely for the use of the individual or
> entity to whom it is addressed. The views expressed may not be official
> policy, but the personal views of the originator.
>
> Whilst Crimson Limited and the sender have taken every precaution to
> prevent transmission of computer viruses, should this inadvertently
> occur we do not accept any liability. Please check for viruses before
> accessing attachments.
>
> If you have received this in error, please do not use, disclose,
> distribute, copy, print or rely on this email - contact the sender and
> delete the material immediately.
>
>  
>
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Migrating MySQL to Sql Server,

Max Kanat-Alexander
In reply to this post by Jason Farmer
On Mon, 2005-06-13 at 13:52 +0100, Jason Farmer wrote:
> My boss has set me the task of implementing Bugzilla on our Windows
> 2003 server using SQL server DB, I don’t know if he has researched the
> implications, so I am assuming not. I am confident that I could get
> Bugzilla up in its own right, but could anyone explain roughly if this
> is possible and what’s involved in achieving this?

        It's not possible, at this point, to run Bugzilla on MS-SQL. MySQL runs
fine on Windows, and Bugzilla also runs fine on Windows, in general.

        We do plan to possibly eventually support MS-SQL, although it's
possible that MS-SQL support will always slightly lag behind MySQL
support.

        You can follow the current bug for this at:

        https://bugzilla.mozilla.org/show_bug.cgi?id=285122

        We'd also love to have your contributions in the area, but do realize
that you'd be getting into a multiple-month project, very likely. You
can come into #mozwebtools on IRC and talk to me (mkanat) or glob (glob
or glob_work) about it, if you want.

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Migrating MySQL to Sql Server,

Max Kanat-Alexander
In reply to this post by Trent Ohannessian
On Mon, 2005-06-13 at 15:30 -0500, Trent Ohannessian wrote:
> I just got Bugzilla set up and running on a DB2 ver. 8.1.5 with minimal
> problems.

        Hey Trent. If you want to file a bug (enhancement severity) in the
"Database" component and attach your patches to it, I'd really
appreciate it. DB2 support would be very cool.

        And of course, if you'd like to work with me and the rest of the
Bugzilla team to get your changes integrated into standard Bugzilla, I'd
be even happier.

        We have a whole framework for cross-DB stuff, nowadays. Feel free to
come into IRC and ask me about it, if I'm around.

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Migrating MySQL to Sql Server,

Trent Ohannessian
In reply to this post by Trent Ohannessian
I would love to work with you and get this code out there.  I went
through this little migration about two years ago, but I horsed it
bigtime so I had to start from scratch, even to the point of writing a
conversion script.  I don't know if I would want to attach my files to a
bug as patches.  I don't know how the patches would play nicely with
other installs.  I fear that if I attach my dozen or so files and
someone else downloads them, it could break their install something
fierce.  If it were for reference, I'd be all for that.  I just don't
want to break someone else's install. :)  I literally got done with this
DB2 migration last week, so I'm going back now to see what needs a
little clean up.  But if you wanted to collaborate with me and get this
integrated into "the stream" somehow, I'd be all for it.

Trent

Max Kanat-Alexander wrote:

> On Mon, 2005-06-13 at 15:30 -0500, Trent Ohannessian wrote:
>
>>I just got Bugzilla set up and running on a DB2 ver. 8.1.5 with minimal
>>problems.
>
>
> Hey Trent. If you want to file a bug (enhancement severity) in the
> "Database" component and attach your patches to it, I'd really
> appreciate it. DB2 support would be very cool.
>
> And of course, if you'd like to work with me and the rest of the
> Bugzilla team to get your changes integrated into standard Bugzilla, I'd
> be even happier.
>
> We have a whole framework for cross-DB stuff, nowadays. Feel free to
> come into IRC and ask me about it, if I'm around.
>
> -Max
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Migrating MySQL to Sql Server,

Max Kanat-Alexander
On Mon, 2005-06-13 at 15:54 -0500, Trent Ohannessian wrote:
> I don't know if I would want to attach my files to a
> bug as patches.  I don't know how the patches would play nicely with
> other installs.  I fear that if I attach my dozen or so files and
> someone else downloads them, it could break their install something
> fierce.  If it were for reference, I'd be all for that.  I just don't
> want to break someone else's install. :)

        Hahahaha, OK. Well, if you could combine them all into one patch
somehow, and attach them to a bug, just make the title "Do Not Use These
Patches" or something like that. :-D *I* personally want them for
reference -- I want to know what needs to be changed for DB2, since I
don't have any DB2 installation to figure that out with.

> I literally got done with this
> DB2 migration last week, so I'm going back now to see what needs a
> little clean up.  But if you wanted to collaborate with me and get this
> integrated into "the stream" somehow, I'd be all for it.

        Great! I'd love that! The best thing to do in this department is to
join the [hidden email] mailing list, and also to come into
#mozwebtools on IRC and discuss it with me. I'll probably be out for
most of the day today, but I expect to be spending significant time on
Bugzilla tomorrow, at the least, so I'll probably be around.

        -Max
--
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools