Developing for the future - SQL*Server

[Edis, Robert]

G'day Guy

I have developed in both PowerHouse and Oracle Designer 2000.  PH is superior especially from a multi-platform perspective.  AFAIK Oracle Designer 2000 will only work with Oracle databases so that would exclude using SQL Server.

I have developed an application using PH Web on a SQL Server backend and deployed it company wide via extra-net.  It worked well, especially the forms.  

SQL Server, especially if you don't need an enterprise license, is cheap, robust and fast and will operate on low (up front) cost servers.  However it will only run on 32 bit Windows boxes.  The 64bit version is still in progress.  A cheaper alternative RDBMS is MySQL on a Linux box but unless you can get a PowerHouse supported ODBC driver for it forget it.

Running PH Web on a separate server to the database works well as the database won't be competing with the web server for resources.  The app I developed was on quad Compaq Proliants with 2/4 GB RAM and lots of disk space (RAID 5).  These ran around USD40K per box but you may need equipment that costs much less.  E.g. a good Dual CPU with 2GB RAM can be got for well under USD10K.

Have fun.

Blue

-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Guy Werry
Sent: Thursday, October 02, 2003 3:09 PM
To: PH Mailing List (E-mail)
Subject: Developing for the future - SQL*Server


We've recently been discussing future development.  Our current Powerhouse /
HP-Ux environment may not be the proper platform for the development being
looked at: long story, don't know if I can get into specifics publically.

So, the discussion has been about doing something in MS Access (user's
idea).  We (I.T. folks) don't like this because of scalability issues,
learning curves, etc.  An alternative idea was MS SQL*Server, which is a
real database.  

What to develop in was the next question.  From some of the discussions that
I've seen on this list in the last while, it looks like Axiant or PH Web on
top of SQL*Server is working well for people.  Is this the case?

One of our consideration is that we have Powerhouse expertise; some Oracle
Forms/SQL experience also, but I don't know what the costs would be like for
the tools and I'm sure that the database admin / purchase costs would be
much better with SQL*Server.

Whaddya think?

Guy Werry.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.