OE 11.x: Looking for a doc that describes everything to be d

Posted by Stefan Marquardt on 26-Nov-2015 03:28

There are many KB articles about D&L in KB, I think too much and not really organized, but I can't find a doc that includes everything.

For convert a Area I DB to Area II I with D&L there is no button dump and load everything in the best way.
There is no proutil -C dump all, everything has to be done manually.
Or do I miss anything?

I have to:

Run a abl code which creates a external script dumping each table
But then I have only the half, _users and sequences are missing. This has to be done manually as well.
Then I hope to be fine with ABL but the DB has SQL information too. (rights, ...)

So my question:
Is there an article/doc where I can check what has to be done to dump & load everything?
I don't want to miss something.

BTW: Writing scripts isn't the problem.

All Replies

Posted by George Potemkin on 26-Nov-2015 03:56

> _users and sequences are missing.

RUN prodict/dump_d.p("_User", ".", ?).

> _users and sequences are missing.

RUN prodict/dump_d.p("_User", ".", ?).

Dump/load sequences by program
https://community.progress.com/community_groups/openedge_development/f/19/t/16512

Dump and Load Strategies Part I: Type II Storage Areas
http://wss.com/en/resources/blog/entry/dump-and-load-strategies-part-i-type-ii-storage-areas

Dump and Load Strategies Part II: Dumping Data
http://wss.com/en/resources/blog/entry/dump-and-load-strategies-part-ii-dumping-data

Binary Dump & Load Checklist
https://community.progress.com/community_groups/openedge_general/w/openedgegeneral/1518.binary-dump-load-checklist

> there is no button dump and load everything in the best way.

"Best way" may mean absolutely different things depending from situation.

Posted by Stefan Marquardt on 26-Nov-2015 04:27

Thanks George,

why I can not use export _user?

Does the dump_d.p handles SQL rights too?

Posted by George Potemkin on 26-Nov-2015 05:46

> why I can not use export _user?

You can.

> Does the dump_d.p handles SQL rights too?

No. It's just the program used by Data Dictionary to dump the application's tables.

How to dump SQL-92 privileges
knowledgebase.progress.com/.../P17829

How do you dump the SQL rights to "_" tables?
knowledgebase.progress.com/.../000045024

Posted by Stefan Marquardt on 26-Nov-2015 07:26

Now we have the general point. KB here and there, I need to know to dump SQL too, that's the point.

The result: SQL connects, ABL connects, OS tools (proutil) or slow ABL (dump_d.p)

3 different kind of Todo to get one data to another db.

High chance to miss something

@PSC: Is this so difficult to provide one doc with the description?

This thread is closed