Questions tagged [progress-database]

Progress OpenEdge Relational Database Management System (RDBMS) is a database server created by Progress Software Corporation.

Filter by
Sorted by
Tagged with
0
votes
2answers
22 views

how to open a corrupted progress v9.1e database

How can I open a corrupted PostgreSQL v9.1e database which has data that was added after it was last backed up?
0
votes
1answer
114 views

How can I stop a single Progress OpenEdge server process and not the whole database?

Is there a way to stop a single _mprosrv process started by the database broker? All I can find from documentation and google searches are ways to disconnect a single user connection or shut down the ...
1
vote
1answer
24 views

locked records progress4gl

I have a query that runs from the sql engine in a progress DB. My problem is when a table or a record is locked from the progress4gl engine, I can't access it from sql engine and the query returns ...
0
votes
1answer
338 views

OpenEdge Progress Replication

There's data sitting in OpenEdge Progress databases. We'd like to replicate that data to a PostgreSQL "datalake" using a software called HVR (high volume replication I think). What the software does ...
1
vote
1answer
685 views

SSIS creates too many connections to a database

I wonder if anyone had experienced anything similar to the following problem? I have a SSIS package containing 10+ data flow tasks which I'm using to extract data from an OpenEdge 11.3.002/Progress ...
0
votes
1answer
187 views

SSIS for/each loop to ETL tables across databases [duplicate]

I have 100 pre-written SQL Server table insert statements, to pull data from a Progress database via openquery into 100 SQL Server tables e.g. insert into table1 (col1 varchar(50), col2 varchar(10)) ...
0
votes
1answer
40 views

Prostrct create causes windows batch file to exit

I have a daily job to restore a database from last night's back up before doing other things to it and moving on. I'm trying to automate this with a script, but when I get to the following command the ...
2
votes
1answer
1k views

Issuing Inserts/Updates to Progress OpenEdge via ODBC

I'm attempting to build some ETL to integrate our SQL Server environment with a remotely hosted 3rd party app running Progress OpenEdge. I have a linked server to it set up in SQL Server 2014. ...
2
votes
6answers
2k views

Export data from a CCURE 800/8000 System using a pair of ODBC data sources?

I'm working on a security system called CCURE 800/8000 and trying to export some entrance / exit data from the Activity Monitor that logs when people use their badges to enter and exit the building. ...
1
vote
1answer
248 views

Partial restore of Progress DB

I have progress .bup files for my databases The environment I am restoring too has less space and because I have no control over this environment I wish to make the databases smaller. To do this I ...
1
vote
1answer
818 views

How do I open a Progress .bup file?

I have a .bup file which is supposed to be a Progress database file. My question is, how can I open/restore it and look at the data?
0
votes
3answers
1k views

Reasons for incremental backup on Progress OpenEdge

In the case that storage is not a problem: are there actually any good reasons for doing incremental backups instead of just doing full backups? Edit This could actually refer to any database with ...
1
vote
3answers
3k views

Select statement is locking a record

We have a process which selects a record from a progress table, then issues an update against that record. If we do not do the select, then the update works all day long. If we do the select, then ...
4
votes
2answers
5k views

SQL Server Linked Server to Progress is slow with an openquery view

We have a SQL Server database setup with a Linked Server setup connecting to a Progress OpenEdge database. We created a SQL Server view (for using with SSRS) of some of the OpenEdge tables using code ...
2
votes
2answers
3k views

Export pipe-delimited data with progress db

I've been handed a task where we need to dump specific tables in a progress database (10.2B) to pipe-delimited flat files (50+ tables) and send them to a third party for analysis every week. Looking ...
3
votes
1answer
241 views

Create incremental/differential backups in ProgressDB

Is there a way to create incremental/differential backups in ProgressDB?
0
votes
2answers
6k views

Progress OpenEdge - how to remove lock from table?

I have some kind of bug leaving lock on table in application that is connecting to Progress OpenEdge Database. Because of the lock I'm not able to test what app is doing wrong there (since I can't ...