BorlandTalk.com

Graham Jones · Guest

Hi,

I have a long standing application that still uses the BDE, the powers
that be have decided (with some persuasion) it is time to finally dump
this obsolete database engine and move to SQL server.

Most of the end users of this application are standalone users, i.e.
single machine environments. A few users are networked, but no more than
5. A requirement has also arisen for a larger user installation of about
50 users.

After perusal of the Microsoft SQL server web pages I see that there is
a desktop engine which would be ideal for the standalone and small
networked users. With the large user installation using the full blown
version of SQL server.

Does all this sound reasonable?

Now, what I liked about the BDE was that I had to do practically zero
support apart from instructing the users to delete all paradox.lck and
pdoxusrs.lck files from time to time. It never, ever caused me any
serious grief which for obvious reasons is good!

So has does MSDE compare? Can I create a nice installation package that
installs it transparently to the user and then will it just work without
any serious support issues?

The large user installation will be maintaining there own installation
so no worries there.

Thanks in advance for any thoughts and comments,

Steve