Comparison between SQL 2000 and Progress db

Hi
Does anybody know of any comparisons or benchmark testing done on SQL 2000
and Progress.?
Also does anybody have any comments on using Progress as a database?
Positive or negative.
We are busy with a evaluation of various software products, and one of the
products use a progress database, the other 2 is oracle and sql2000.
My biggest concerns is the application using the progress database, as I am
not a progress developer, or do I have any knowledge about the product.
Can anybody give me more information, personal experience, or point me to a
web site with relevant information.
Thank youHello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for Progress its too niche. As a database its ok, you have all the normal columns, foriegn keys relationships. From a DBA point of view its a bit of a pain as you don't have the tools as you do in SQL server or Oracle. A good example is that we have a 1 gb production database that can only be backed up once an hour, and it needs to be a total backup, rather than say a transactional backup.
Transfering data from progress to Window Application is a pain, mainly due to the Progress Application we use are all Unix based so we have to write to a text file. There is an ODBC tie into Progress but its an extra, I believe that it costs =A310k +.
Progress itself is both a Database and Application package, i.e. the code works seemlessly with the database. The progress sql is different to T-SQL and PL-SQL so you will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have activly been recruiting Progress programmers for some time and cannot find them, as opposed to SQL Server and Oracle where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as a database?
>Positive or negative.
>We are busy with a evaluation of various software products, and one of the
>products use a progress database, the other 2 is oracle and sql2000.
>My biggest concerns is the application using the progress database, as I am
>not a progress developer, or do I have any knowledge about the product.
>Can anybody give me more information, personal experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>|||Thanks for your post Peter.
I appreciate and value your comments.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:922201c43359$934a6a10$a601280a@.phx.gbl...
Hello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for
Progress its too niche. As a database its ok, you have all
the normal columns, foriegn keys relationships. From a DBA
point of view its a bit of a pain as you don't have the
tools as you do in SQL server or Oracle. A good example is
that we have a 1 gb production database that can only be
backed up once an hour, and it needs to be a total backup,
rather than say a transactional backup.
Transfering data from progress to Window Application is a
pain, mainly due to the Progress Application we use are
all Unix based so we have to write to a text file. There
is an ODBC tie into Progress but its an extra, I believe
that it costs £10k +.
Progress itself is both a Database and Application
package, i.e. the code works seemlessly with the database.
The progress sql is different to T-SQL and PL-SQL so you
will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have
activly been recruiting Progress programmers for some time
and cannot find them, as opposed to SQL Server and Oracle
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as
a database?
>Positive or negative.
>We are busy with a evaluation of various software
products, and one of the
>products use a progress database, the other 2 is oracle
and sql2000.
>My biggest concerns is the application using the progress
database, as I am
>not a progress developer, or do I have any knowledge
about the product.
>Can anybody give me more information, personal
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>