Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 43

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 20th December 2004, 10:57
indian_sumesh's Avatar
indian_sumesh indian_sumesh is offline
Join Date: Dec 2004
Location: Pune
Posts: 93
indian_sumesh is an unknown quantity at this point
Baan: B40c4in5 - DB: Oracle10g - OS: Sun Solaris
How to copy live company(e.g 198) table data to test company(e.g. 118)

I am new user of BAAN IV

How to copy live company (e.g 198) table data to test company(e.g. 118)

I need this help urgent
Reply With Quote
Old 20th December 2004, 11:27
Guillaume.G's Avatar
Guillaume.G Guillaume.G is offline
Join Date: Aug 2002
Location: Lyon - France
Posts: 72
Guillaume.G is on a distinguished road
Baan: ERP LN (All), Baan IV & Triton - Infor OS - ION- Warehouse Mobility - DB: Oracle, SQLserver, Bisam - OS: WIndows, Unix/Linux

one solution is
- to make an export with baan tools (ttaad4226m000)
- to make an import with baan tools (ttaad4227m000)
and after start the session to change the compnies number in the baan tables, this session is tfgld9000m000, tfgld9001m000, tfgld9002m000 AND tfgld9003m000 - Or you can run the tfgld9004m000 wich are then combinaison of the fours sessions.

then disavantage of this solition: if your live companies is big, the export/import with the baantools can be very long.


Reply With Quote
Old 20th December 2004, 11:52
victor_cleto's Avatar
victor_cleto victor_cleto is offline
Join Date: Aug 2001
Location: Portugal
Posts: 776
victor_cleto is on a distinguished road
Baan: none (B40c4 was last) - DB: Oracle - OS: Linux (RHEL)
While doing the export, the users that work on company 198 must be logged off to avoid table locks, so plan the export for when people is not working (even jobs).
Same goes for the import, but since that is a test company, just keep the test users out.
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy software component to live mostrightfuture Tools Development 6 21st July 2004 12:06

All times are GMT +2. The time now is 21:09.

©2001-2018 - -