I should have asked this question before I got to this stage:
Intranet; Win2k / CF5
Which DB should I use?
Background:
I've an intranet which has been working on Win2k / CF5 / Access just
fine for the last couple of years. About 6 months ago I warned the big
chiefs that the DB was beginning to get rather large and it was a good
idea to consider moving to a proper DB for all the good reasons
discussed here and elsewhere many times.
M$ SQL server was the obvious choice but when they looked into it they
got a big fright on the licensing costs; something around 15 - 20,000
GBP apparently. (some 200 clients use this intranet).
I did a brief test of MySQL on my dev server - all too brief as it turns
out - and it looked OK so "Why not use MySQL?" says I, commercial
licence is 500 Euros, unlimited clients, and the new version supports
all the 'advanced' features you need. Last week at a meeting with all
the bigwigs it was agreed.
So what happens? I've got a really intractible problem where text
fields longer than 255 aren't being returned properly. Whether it's an
ODBC problem, a DB problem or a simple configuration problem I don't
know, I'm trying to find out, but at the moment my conversion has fallen
over at the first hurdle as client vars in CDATA.DATA aren't being
returned properly.
This is MySQL 4.1 I expect I could go to an earlier version, but this
new version supports transactions, subqueries and UNION statements, and
this intranet app is stuffed full of all of them. It would be a hell of
a job to undo all that....
--
Regards;
Richard Meredith-Hardy
-------------------------------------------------------------
r.mh[at]flymicro.com
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
