Sceduled ascii dump

[gerie]

Every week I make an ascii dump of the database in order to fill the data ware house of an organisation. The data ware house is ofcourse not a progress database. I use the data administration tool to create the dump.
Is there a way to scedule this dump?

Env. WS2003 Standard ed.
Progress 10.1B

Thanks in advanced,

Gerie

 

[TomBascom]

You could use the windows task scheduler. But first you will have to write a script or put together a 4gl program to actually do the dump. It isn't especially hard. For each table being dumped the data dictionary basically does:

output to value( "dumpname.d" ).
for each tablename no-lock:
  export tablename.
end.
/* write a trailer that your data warehouse load probably ignores */
output close.

 

[gerie]

Thank you, I'll try and test that.

 

[RealHeavyDude]

You might also have a look at the knowledge base article P10208 "How to perform a batch ASCII dump".

It describes exactly what you need.

http://progress.atgnow.com/esprogress/searchResults.do


HTH, RealHeavyDude.

 

[gerie]

I'm sorry Realheavydude, I can't find the article you are relating to.

 

[gerie]

Found it, sorry.

 

[garym@camgar.ca]

There are several ways to do it.

One is that you can just have a program that does (using a table called customer as an example):
output to cust.d.
for each cust no-lock:
export cust.
end.
output close.

Or another way is to have a program that calls the Progress routine that dumps data but in the end you end up with the same thing.

Hope this helps.

Gary Mittleman
garym@camgar.ca