I am trying to sift through the various sources of information on bdbpre and bdbpost.

I know how to create a sequential dump file using BDBPRE and want to script the sequential dump along with a load.

I plan on using the command line:

D:\BAAN\BIN\BDBPOST -kmnif -I L:\CO160.DMP -q L:\CO160LOAD.ERR

to do the load.

If I was doing the load from ttaad4227m000 and checked ignore referential integrity constraints I would be prompted to run ttaad4225m00 after the load to repair the reference counters.

Since the -n ignores referential integrity constraints do I need to run bdbreconfig or ttaad4225m000 after the bdbpost load?

Thanks

Stephen

Yes,

Run the reference check/repair afterwards.

That is, unless you are sure that the data you are loading does not comprimise reference integrity - as maybe the case for certain tables. If you're not sure, then run it anyway.

if your dump is huge say greater than 10GB ...you can just select the options data indices and reference integrity in session ttaad4225m000.

On the other hand for a small database go ahead and do a reorganize with repair refernce counter activated.

If one is sure about the data then u need not reorganize tables .....though this is not the said practice. We have around 40GB of data and recently we distributed our complete database without reorganising tables ....the system is working fine.

Do let me know if this helped you and post your views also.

If you are running Baan IV or older Triton versions, you have to run the refint part of the session ttaad4225m000. Don't check "Data and Indices", because this would dump and reload the data again. If you use the -n option for bdbpost, the refcounters are not updated, so this has to be done afterwards.

If it`s Baan ERP, you are workíng with, you need to do it only for the txt tables, because in all other moduls, reference counters are not used anymore.