Take a Look at SQLAnywhere from Sybase. It is not as expensive as
Microsoft SQL server and the performance is really good. We have some
customers that upgraded ACCESS systems to this DBMS and are really happy
with it.
http://www.sybase.com/detail/1,3693,1002624,00.html
It is sold as SQL Anywhere Studio. Don�t be fooled by the name. It
includes a powerful DBMS that is perfect for ColdFusion applications
(but again, and as many other list members will reply, it all depends on
what kind of growth you are expecting in the following years)
Regards!
Ricardo Villalobos
Dimasys, Inc.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Brian Thomas
> Sent: Tuesday, August 21, 2001 1:40 PM
> To: [EMAIL PROTECTED]
> Subject: Upgrading our database
>
>
> Hi everyone,
> We are in the early stages of looking for an upgrade to
> our current Access database. Yes, I know. Access is slow. We
> only handle a small amount of data, but performance is
> becoming a problem. Some of our tables have 15,000 records,
> but that is the largest so far. We are anticipating breaking
> 30,000 records per table soon though.
> My question is, for a 2-person IS department at a very
> small company, should we upgrade to SQL? Is there another
> database short of Oracle (remember, only 2 people) that would
> require less setup? I am also concerned about migration. If I
> set up new datasources in CF, could I copy my macros into
> SQL? Or, would I be better pursuing another route?
> I know everyone has a favorite database, so please let
> me know the pros and cons.
>
> Thanks,
> Brian Thomas
>
> --------------------------------------------------------------
> -----------
> This email server is running an evaluation copy of the
> MailShield anti- spam software. Please contact your email
> administrator if you have any questions about this message.
> MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
