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 j
>
> 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
>
> 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 i
o [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 can be a royal pai
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:
> >
>
> -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
&g
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 J
>
> 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
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
d
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
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 releas
>
wrote:
> > -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
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 i
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
footp
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
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 PROT
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 without
> -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
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 t
; > Sent: Sunday, March 16, 2008 7:44 AM
> > To: CF-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 CFEc
ement tools.
Russ
> -Original Message-
> 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, wi
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
22 matches
Mail list logo
