HI,
Is there a software or procedure to migrate DB from COBOL to SQL ( or postgresql)
thanks a lot
bela

How is the data in the "COBOL" system being stored? DB2? Flat files?

Why this question?
Is there differents procedures ?
say both !

Is there a procedure from inside postgresql ffor example ??

thanks for help
regards

Uhm, you don't know how the data you need to migrate is being stored or what format it's in? You don't know whether it's stored in files or in a DB2 database or in some other format? OBVIOUSLY, we need that information before we can recommend anything. Especially anything automated.

What you will likely end up doing is this. First you would create a script containing SQL CREATE statements to create the tables and relationships you need in the postgresql database. Then you would export the data you need from the "COBOL" system (note: COBOL is not a data storage format) and transform it into a script full of SQL INSERT statements. Then you would run both scripts on the postgresql system to create the tables and insert the data.

EDIT: if the data in the "cobol" system is in a db2 database, then you should read this document:

http://wiki.postgresql.org/wiki/File:DB2UDB-to-PG.pdf

Let's not be daft here. COBOL is a programming language. How can we possibly advise you on migrating from a programming language to a database?

Migrating from legacy systems (read: large mainframe transactional systems) to new languages and databases is a huge undertaking. It often requires a well-coordinated staff of business experts, programmers, sysadmins, and database administrators. And these projects sometimes fail.

Did I misunderstand you? Are you asking how to migrate a single table from DB2 to PostgreSQL? Are you highly familiar with the table design and data?

Thanks for help

In fact I have a Database written in Cobol, I want to migrate it to serveur using postgresql.

thanks a lot

Then you already knew the answer to your original question: it's a proprietary database system used only in your organization, so obviously no automated tool or procedure exists.

I've told you what you need to do in post #4.

Of course not.

If you can tell us the name of the database software that's written in COBOL, or any of the other information that I asked for, then the answer might change.

I'd add that if your proprietary database is hierarchical in design, you will want to do a complete analysis of the table data before attempting to stuff it into a relational database. (For instance: rows may need to be "flattened", and significant work may need to be done to determine suitable primary keys.)

my recomendation would be to look at this http://www.simotime.com/cblcsv01.htm document and write a program to dump your data to csv files, then import them into your postgresql database.