If only 2 people are going to be using this app, you can use Microsoft's MSDE
database. This is a desktop version of SQL Server. You can use stored procedures,
triggers, views, etc.
This would be my suggstion unless you have the money to get true SQL Server.
Clint
---------- Original Message ----------------------------------
From: Brian Thomas <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 21 Aug 2001 13:39:35 -0500
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
