Progress vs. MS SQL Server 
Author Message
 Progress vs. MS SQL Server

What would be a better database decision for a 1000 employee/ 12
location  firm? We have a WAN already in place with ample bandwidth.

We are currently using Progress v6 & DOS & NetWare 3..x and are moving
to Windows NT 4.0 over the next few months.

Should we bother migrating to Progress v8 or, since we are going to
NT, migrate to MS SQL server?

What are the issues?

Please advise.



Mon, 28 Aug 2000 03:00:00 GMT
 Progress vs. MS SQL Server

I have used both fairly heavily and prefer Progress.
SQL Server is much less expensive, but I preferr having both the SQL
interferface and the traditional For Each tablename
programming constructs.
SQL server is totaly SQL based

Bob


Quote:

>What would be a better database decision for a 1000 employee/ 12
>location  firm? We have a WAN already in place with ample bandwidth.

>We are currently using Progress v6 & DOS & NetWare 3..x and are moving
>to Windows NT 4.0 over the next few months.

>Should we bother migrating to Progress v8 or, since we are going to
>NT, migrate to MS SQL server?

>What are the issues?

>Please advise.



Mon, 28 Aug 2000 03:00:00 GMT
 Progress vs. MS SQL Server

Well, let's see.  I have the 'opportunity' of working with 1 MS SQLserver
db, 18 Progress Dbs, and 4 ORACLE Dbs.

MS SQLserver has some very strange quirks- and it only will run on NT.
It's utilities are strange,  like the tool that will allow you to (while
online) wipe out the recovery logs (equivalent to emptying the AI files in
Progress w/o backing up).  Our MS SQLserver db is less than 1 Gb and gives
us more problems that Progress / ORACLE combined.  Beside, even all the
Progress tools available under UNIX are not there with Progress Server for
NT (at least with V7.3D).

What I believe is the ultimate scenario for NT- Progress servers on UNIX
(HP, Sun, or IBM RS), middle-tier client code on a NT server, and NT WS
clients.

IMO, getting away from Novell is a real plus- just try to consider other
options beside MS SQLserver.


Progress DBA
Alcoa Fujikura, Ltd.
San Antonio, TX.

Quote:

> What would be a better database decision for a 1000 employee/ 12
> location  firm? We have a WAN already in place with ample bandwidth.

> We are currently using Progress v6 & DOS & NetWare 3..x and are moving
> to Windows NT 4.0 over the next few months.

> Should we bother migrating to Progress v8 or, since we are going to
> NT, migrate to MS SQL server?

> What are the issues?

> Please advise.



Thu, 31 Aug 2000 03:00:00 GMT
 Progress vs. MS SQL Server

We run both SQL server (for our financials) and Progress 8.1 (Unixware).
Three issues we see are:

1.  SQL Server does not perform as well as Progress.
2.  SQL server is more complex to implement and maintain (i.e., space and
log files must be pre-allocated and managed for optimum performance,
limited utilities and performance monitoring tools).
3.  There are things that can be done with the Progress 4GL database
language construct that just can't be done using SQL.
 Hope that helps.



Sat, 02 Sep 2000 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Progress vs. MS SQL Server

2. Sybase ASA vs MS Access vs MS SQL Server

3. Sybase ASA vs MS Access vs MS SQL Server

4. Sybase ASA vs MS Access vs MS SQL Server

5. ORACLE vs INFORMIX vs MS SQL SERVER

6. Oracle vs Sybase vs MS SQL Server

7. MS SQL Server vs. Oracle SQL Server

8. Progress v6 vs. MS SQL

9. MS SQL vs Progress

10. MS SQL Server vs Oracle vs DB2 (&Sybase too)

11. ORACLE vs INFORMIX vs MS SQL SERVER

12. MS SQL Server vs Oracle vs DB2 (&Sybase too)


 
Powered by phpBB® Forum Software