Baan IV to Infor LN Data Copy Downtime Calculator (bdbpre/bdbpost)
This calculator estimates the downtime window for moving table data with bdbpre and bdbpost, whether you are copying companies or moving Baan IV or LN data to a new server as part of a migration. It works from throughput measured on a test copy and shows how far parallel table lists shorten the window.
Your numbers
Data to dump and load, from your table list.
Measure on a test run; not a vendor figure.
Import is usually slower than export because indexes are built.
Separate table list files run at the same time.
Below 100 because streams share disk, CPU and the database.
Your results
Throughput figures are inputs from your own test copy, not Infor numbers. Parallel streams stop helping once disk or database I/O is saturated. Data conversion steps of a Baan IV to LN migration are not included and must be timed separately.
Total window (hours) vs parallel streams
Sweeps Parallel streams from 1 to 12, holding your other inputs fixed.
Get your cutover window reviewed
Send us your test-copy timings and table list split and we will review the downtime plan with you.
Optional. The tool and every export work without this. No spam.
Where bdbpre and bdbpost fit
bdbpre dumps tables to sequential files and bdbpost creates tables from those files. In LN the sessions Create Sequential Dump of Table (ttaad4226m000) and Create Table from Sequential Dump (ttaad4227m000) use the same executables (bdbpre6.2 and bdbpost6.2). Infor documents a command-line method: list the tables in an ASCII file, dump them with bdbpre, load them with bdbpost. When the load runs with Ignore Referential Integrity Constraints selected, the imported records get reference counters of zero, so you must run Reorganize Tables (ttaad4225m000) with Repair Reference Counter afterwards. To import data exported from another company, first run Copy Company Data (tccom0214m000) on the sequential files to correct company number references; it needs dumps made with field separators.
How to use it
Run a full test copy of a representative subset, note GB per hour for the dump and for the load per stream, and enter them. Split the table list into several files of similar size and enter how many will run in parallel. Enter reorganize time as a share of import time from the same test, add validation and sign-off hours, then a contingency.
- Export hours = GB / (bdbpre GB/h x streams x efficiency)
- Import hours = GB / (bdbpost GB/h x streams x efficiency)
- Reorganize hours = import hours x reorganize %
- Window = (export + import + reorganize + validation) x (1 + contingency)
Worked example
300 GB with 4 streams at 80 percent efficiency gives 3.2 effective streams. Export at 20 GB/h per stream takes about 4.7 hours, import at 12 GB/h about 7.8 hours, reorganize at 25 percent of import about 2.0 hours, plus 4 hours of validation, so about 18.5 hours. With 20 percent contingency, book about 22 hours. The chart shows the window falling quickly from 1 to 4 streams, then flattening, because validation is fixed and real systems hit an I/O limit.
Gotchas
Put the largest tables in separate lists so one stream does not finish hours after the others. Load without referential integrity checks for speed but never skip the reference counter repair, or records that are still in use can be deleted later. If you dump with Exclude Logical Tables From Dump selected, each skipped logical table is logged in dump.err: check it. For Baan IV to LN, table structures differ, so the migration tooling and conversion runs add time beyond the raw copy.
Frequently Asked Questions
When does Baan IV support end?
Support status for Baan IV is set by Infor's product lifecycle policy and your own support contract, so check it with Infor for your release. This calculator does not depend on the date; it helps you plan the data move whenever you decide to make it.
Can I copy Baan IV data straight into Infor LN with bdbpre and bdbpost?
Only where the table structures match. Baan IV and LN tables differ, so a migration uses conversion tooling between the dump and the final load. The dump and load steps are still useful for moving data between servers and for company copies, and that is what this calculator times.
Why do I need ttaad4225m000 after bdbpost?
If tables are loaded with referential integrity ignored (the Ignore Referential Integrity Constraints check box in ttaad4227m000), imported records get a reference counter of zero. Reorganize Tables with Repair Reference Counter selected rebuilds the counters so LN does not allow deleting records still used by other tables.
How many parallel streams should I use?
Test it. Start with one stream per spare CPU core and disk path, and stop adding streams when total throughput no longer rises on your test run. Splitting large tables into their own lists usually matters more than adding streams.
If you are moving off Baan IV and want a private AI assistant over the new LN system from day one, we can plan both together.
Related Tools
Infor LN Database Growth by Table Calculator
Estimate how fast the main LN 10.x transaction tables grow from your order volumes, and how many GB you need after N years.
Infor LN & BaanBaan Data Migration Effort Calculator
Estimate the hours, cost, and timeline to migrate your Baan data to Infor LN based on table scope, record volumes, data quality, and load iterations.
Infor LN & BaanBaan to Infor LN Migration Readiness Assessment
Score your organization's readiness to migrate from Baan IV or Baan V to Infor LN across ten dimensions, from data quality to executive sponsorship.
Infor LN & BaanInfor LN Cutover Runbook Template
Editable task-by-task cutover plan with owners, durations, dependencies and total cutover hours.
More Infor LN & Baan tools
See all- Infor LN Common Data (tcmcs) General Tables Reference
- Infor LN Enterprise Server Error Codes and Log Files Reference
- Baan IV and Infor LN BSE Command-Line Tools Reference
- Infor LN bdbpre and bdbpost Table Copy Command Generator
- Baan IV End-of-Life Risk Cost Calculator
- Infor LN Upgrade Cost Estimator
- Infor LN vs SyteLine Selector
- Infor LN Multi-Site Rollout Planner
- Infor LN Customization Complexity Scorer
Keep exploring
Free tools
- Infor LN bdbpre and bdbpost Table Copy Command GeneratorGenerate the table list file and the bdbpre and bdbpost commands to copy tables from one LN company to another, with the follow-up reorganisation steps.
- Infor LN and Baan ERP Table List by PackageFilterable list of commonly used Infor LN and Baan tables by package, with the naming convention, key fields and where a Baan IV table differs from LN.
- Baan to Infor LN Migration Readiness AssessmentScore your organization's readiness to migrate from Baan IV or Baan V to Infor LN across ten dimensions, from data quality to executive sponsorship.
ERP fixes and how-tos
- Baan IV to Infor LN migration checklistPlan a Baan IV to Infor LN move as a re-implementation, not a patch: inventory customizations, convert data, rebuild logic, and run a real parallel test.
- Private AI Layer for Baan On-Prem: Reference ArchitectureReference architecture to add a private AI assistant to Baan on-prem: data access paths, retrieval, permissions, sizing and rollout, no cloud needed.
- How to Create an Infor LN User from a User Template and Copy AuthorizationsCreate Infor LN users from user templates and roles, copy authorizations safely, and avoid the common mistakes that give new users too much or too little.
Guides
- Baan ERP End of Life: What Are Your Real Options?Baan IV and Baan V are end-of-life. Explore your migration options to Infor LN, CloudSuite, or alternative ERPs with realistic timelines and costs.
- BAAN IV End of Life: Migration Options and Upgrade PathsBaan IV end-of-life migration options: upgrade to Infor LN (12-18 months), Baan to SAP S/4HANA (18-30 months), cloud ERP, or staged modernization.
- Baan ERP: History, Versions, and Modern Migration PathsBaan ERP history from Triton to Baan IV, Baan V, and Infor LN, plus practical migration paths for manufacturers still running Baan today. Get a proven roadmap.
Integrations
- How to add AI agents to Baan IV and Baan VHow to add AI agents to Baan IV or Baan V: tool layer over read-only database access and AFS, human approval on writes, and an on-prem model. A practical guide.
- How to use ChatGPT with Baan IV and Baan VUsing ChatGPT with Baan IV or Baan V: exports versus live access, custom GPT actions, enterprise data controls, and when a private on-prem model is the safer choice.