On Friday 15 July 2005 06:24, Chris wrote:
> Our company has a project to migrate some financial
> software from a Microsoft Access 97 database.
<snip>
> The taget platform will be Windows 2000. The
> application is written in Visual Basic (VB6), but is
> likeley to be rewritten at some point *after* the
> database convesrion.
> The main requirements are:
> * Low Cost
<snip>
> The obvious solution seems to be to migrate the
> database to MS SQL Server Express.
<snip>
> The databases can be viewed
> by support staff using ACCESS 2002, which has the
> advantage of having a small lurning-curve from access
> 97. We are way below the limits currently imposed on
<snip>
> I do have worries about Microsoft changing the "free"
> licensing or reducing the limits in future releases.
<snip>
The main issue that would concern me is that you're going to move to a new m$
product on an obsolete m$ platform (w2k). While you might be able to get
the databases for "free", you might want to factor in the cost of upgrading
your OS to something that m$ will support you on. If you swap to PostgreSQL,
I suspect we'll support w2k for quite some time longer, but even if not you
could swap to *nux as well and not have to pay os licensing fees.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL