We made the move to E10 back in November, and have left V8 up for people to access historical data. The E10 was a clean install, with only the minimal data exported from V8 and imported (via DMT) to E10.
Now IT wants to take the V8 server down (it is running on Winserver 2003).
But before they do, I’d like to archive some key tables, in a way that I could run queries against - should someone need something from our old V8 db. Entire tables will be exported. The pseudo SQL query would be:
SELECT * FROM PUB.Part Part_0
I was going to just run ODBC queries against the Progress V8 DB, from right inside Excel. Making 1 excel file for each table I exported from V8.
But many of the tables have more columns than the OpenEdge ODBC drive can handle. And some data in fields that exceed the db’s field width. Either of cases makes an ODBC connection fail.
Is there a simple (i.e. free ) tool to export tables from the Progress DB, to another format like SQL tables?
Thanks in advance,