Dear all,

Because we are going to move from HPUX to a linux environment, we've to export the 000 company.

For me, the best option is the bdbpre6.1 command with the following arguments

bdbpre6.1 -x -o /home -C 000 -q cia.000.dmp -E error.000.log

I would appreciate some piece of advice from anyone who has dealt with this situation.

Joan

Doing -C won't give you all tables in company X.

in $BSE/lib/ora/ there is a shell script or a .sql script that will create an I file for a company. (or you can just write you're own sql to extract it..)
OR you can just use export tables from within Baan.

You can do that and then do
bdbpre6.1 -I<filename> -C0 > 000.dmp

pre files are surprising relsiliant especally when moving from one flavor of unix to the next. just make sure to xfer with scp or binary mode ftp. I also usually gzip it just to be 100% sure that there is no character conversion on xfer.

Another option would be to do a db style export

Dave

I am migrating a customer from Windows to AIX and contemplated the idea of dumping the whole company 000 from Win and importing it back in AIX. I finally decided to only do that selectively only for the stuff I knew I was going to need like users & authorizations via the provided objects for it (the name of the object slips my mind right now) devices via bdbpre, etc.

Joan, I am curious to know why you decided to do the whole company 000. Not that it is wrong but on the contrary because I am still on time to re-evaluate.

Thank you,

Eduardo