-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 11:24 AM
To: CF-Talk
Subject: Re: DB choice for small Intranet site
I have no problem with MSSQL. You should note the Express management
console
does not support import and export which
No-Blanket-statement rules suggest that Microsoft is exempt since it has
been found that in 90% of cases (my own survey) that it is true therefore
earning a go card for all blanket statements against it. :-)
-J.J.
On Sun, Mar 16, 2008 at 5:46 PM, Dominic Watson
[EMAIL PROTECTED] wrote:
As
]
Sent: Sunday, March 16, 2008 11:24 AM
To: CF-Talk
Subject: Re: DB choice for small Intranet site
I have no problem with MSSQL. You should note the Express management
console
does not support import and export which can be a royal pain when moving
from devel to production. The full evaluation
If anyone knows a way to import/export using a tool like SQL Server
Management Studio Express, or any tool that would connect to a Virtual
Hosted MSSQL database, could you let me know? I see this project coming
in
the near future and my previous research indicates no 'good' way to do it.
You may have to jump a few hoops to get the DTS 'plugin' to work but maybe
not...
I should clarify; there is no issue with it working, you just may need to
add it to the 'external tools' list in Management Studio Express to access
it from within the studio; google should help with that. It's
That is exactly what my blog post was about.
Russ
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 11:46 AM
To: CF-Talk
Subject: Re: DB choice for small Intranet site
You may have to jump a few hoops to get the DTS 'plugin
Which DB would you choose (MSSQL Express / Apache Derby) for a small (4gb,
with only 10 simultaneous connections) intranet CF App?
I only used MS-SQL before, and I found the management studio very easy to work
with. The only concern I have is the limitation of the Express version might
get
-
From: henry ho [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 7:44 AM
To: CF-Talk
Subject: DB choice for small Intranet site
Which DB would you choose (MSSQL Express / Apache Derby) for a small
(4gb, with only 10 simultaneous connections) intranet CF App?
I only used MS-SQL
-Talk
Subject: DB choice for small Intranet site
Since there's no management studio like MSSQL for Derby (or MYSQL),
anyone
tried RDS support in CFEclipse? Can I use that to create/manage/backup
the
DB? Is it reliable
The first thing that popped in my head was MySQL.
Samll, light weight and faast. I have been using it on production
sites (CF and PHP) since v 3.x and only had 2 beefs with it. I had couple
table corruption errors a few years back which repair fixed nicely. The
other was not being able to
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 10:22 AM
To: CF-Talk
Subject: RE: DB choice for small Intranet site
Personally, I like MS SQL Express. The only thing is that it doesn't
come
with an agent, AFAIK, so you'll need to find another
I am not much of a MSSQL person but if you meet that limitation one day,
can't you easily upgrade things into the full version?
I have been using Oracle XE for similar needs that you have and also for
moving things to/from development workstations to our development/production
environments
I remember looking at Oracle XE(?) a year or so ago. Doesn't it suck up a
couple of hundred megs of ram? Or was that something else? I don't remember
which version I tried out but I *do* remember it was using some ungodly
amount of ram.
G
On Sun, Mar 16, 2008 at 11:42 AM, Aaron Rouse [EMAIL
On Sun, Mar 16, 2008 at 8:21 AM, Russ [EMAIL PROTECTED] wrote:
This is the first I'm hearing of Apache Derby, and although I'm sure it's a
nice project, it's written in Java, which means it will be slower then MSSQL
Just because it's java doesn't mean it's got to be slow. :]
HSQLDB is
I would go with MySQL and yes there are GUI's out there such as NaviCat,
which I personally use, that rival Enterprise Manager and the Management
suite. I also like the fact it isn't microsoft. It scales rather nicely so
there are few to no limitations on it. It also has a fairly small memory
I honestly have never paid attention because never had RAM issues. I do not
think my 2003 box here has more than a few gigs of RAM in it and it is used
for MSSQL Express, Oracle XE, Active Directory for the domain, minimal
shared file storage and ColdFusion 8 and it never has resource issues and
[mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 10:22 AM
To: CF-Talk
Subject: RE: DB choice for small Intranet site
Personally, I like MS SQL Express. The only thing is that it doesn't
come
with an agent, AFAIK, so you'll need to find another way to do backups.
I second SQL Server
The last small project I developed was a sales application that met the limits
you mentioned (4Gb and 10 connections) . I compared MySQL (which I am a big
fan of), and MS SQL Express. My customer was on a very tight budget and a
commercial license (because the software is private and not
denstar wrote:
On Sun, Mar 16, 2008 at 8:21 AM, Russ [EMAIL PROTECTED] wrote:
This is the first I'm hearing of Apache Derby, and although I'm sure it's a
nice project, it's written in Java, which means it will be slower then MSSQL
Just because it's java doesn't mean it's got to be
henry ho wrote:
Which DB would you choose (MSSQL Express / Apache Derby) for a small (4gb,
with only 10 simultaneous connections) intranet CF App?
Of the choices you present I would choose MS SQL Express. Derby is
either a hassle to install, or you need to run it embedded in CF which I
do
As far as saying Apache Derby being slow just because it is on top of Java
is pretty baseless and making blanket statements like that are just about
as
bad as saying ColdFusion sucksand is slow because MySpace crashes all the
time.
As much a blanket a statement as I also like it cos its'
On Sun, Mar 16, 2008 at 3:27 PM, Jochem van Dieten
[EMAIL PROTECTED] wrote:
denstar wrote:
On Sun, Mar 16, 2008 at 8:21 AM, Russ [EMAIL PROTECTED] wrote:
This is the first I'm hearing of Apache Derby, and although I'm sure
it's a
nice project, it's written in Java, which
22 matches
Mail list logo
