Runrev & Microsoft sql server

[Nic Prioleau]

Thank you Len,

In answer to your questions...

1) This will be a multiuser database.
2) Server and clients should always be on the same subnet.
3) I think we should definitely give the option of running this app on other 
OS's.

So it looks as though you've answered my question about SQLExpress.. :)

But since I have never used PostgreSQL, I am unfamiliar with deployment. Is 
this a simple process? I imagine I would have to be able to do a server 
install but what (if any) adjustments need to be made after installation. 
I've experienced various issues with mySQL as far as priviledges, etc, are 
concerned and various .php files need to be edited before a stable/secure 
installation is achieved.

Thanks
Nic
----- Original Message ----- 
From: "Len Morgan" <len-morgan at crcom.net>
To: <use-revolution at lists.runrev.com>
Sent: Thursday, April 12, 2007 6:01 PM
Subject: RE: Runrev & Microsoft sql server


> While I haven't used SQLExpress, I HAVE used SQL Server.  If your problem 
> with mySQL (which I am NOT recommending), is the difficulty of setting up 
> the server, I don't think you're going to do any better with SQLExpress. 
> Some things you didn't mention:
>
> 1) Will this be a multiuser database?
> 2) Will you the server and clients be on the same subnet?
> 3) Is there any (future) possibility of the server running on something 
> besides an MS OS?  If so, forget SQLExpress
>
> If it were me, I'd use PostgreSQL.  They have a native Windows port with a 
> simple installer.  It's really FREE to use in any way you want, has 
> unlimited users and there is a Rev driver for it.  With SQLExpress, you're 
> going to have to use ODBC and that means you'll have to set up DSNs on 
> every client machine.  I'm not sure if this last step can be scripted and 
> I'm pretty sure you'll need Admin rights on the client machines to set 
> this up.  PostgreSQL doesn't require this (on the clients).
>
> If this is not a multiuser app, you could look into SQLLite but I think 
> that only runs on the local machine (I could be wrong).  In any case, it's 
> a single user database.
>
> Hope that helps,
>
> Len Morgan
>> The application will not have huge amounts of data. It is being developed 
>> towards small to medium business.
>> Does anyone have any experience with sqlExpress? I know that it's free 
>> for distribution and does not require licences. Does anyone have any 
>> suggestions as to what we could use instead?
>> I could develop in .NET but really like revolution and would like to 
>> stick with it for as long as I can.
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 


#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################