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.
> _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.
Thanks George,
why I can not use export _user?
Does the dump_d.p handles SQL rights too?
> 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
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?