Hello Everybody,

I have Baan IV C4 , and a package VRC say BCD for my live company. For testing purpose I wish to transfer tf,tc,td,ti related tables and data of BCD Company to another machine. How is this possible. Please Help

Regards

Dheeraj

Hi Dheeraj

> For testing purpose I wish to transfer tf,tc,td,ti related tables

Since I don't know your level of customizations on that layer, it's best to export software components from that package combination to your test machine package combination.

Use the "Export Data Dictionary" session (ttiex1280m000) to export them (by package VRC) and import them into the destination using "Import Data Dictionary" (ttiex1285m000).

This will ensure the same level of software components.
You may need to convert to runtime depending on what components you have transfered.

> and data of BCD Company to another machine. How is this possible. Please Help

Export your company using "Create Sequential Dump of table" (ttaad4226m000) and then import it into the destination company using "Create Table from Sequential Dump" (ttiex4227m000). If the destination company number is different from the original, you need to renumber it (using session tfgld9004m000).

Try to get more information regarding the usage and settings of the sessions mentioned. You can always post here your doubts later on.

Hello Victor,

Thanx for replying. Do only following two steps are needed


1. Export/Import Data Dictonary

2. Dump Sequential Tables/Create Tables from Seq Dump

During this process, on create Sequential Dump, there is option for Specify Database Driver, Create Fixed Length Records, specify field separators, can u tell which option is useful during this operation.

Regards

Dheeraj

> During this process, on create Sequential Dump, there is option for Specify Database Driver, Create Fixed Length Records, specify field separators, can u tell which option is useful during this operation.

Specify Database Driver: No (unless you use different databases with Baan)
Create Fixed Length Records: No (unless you will import data into specific programs like Excel, etc.)
Specify field separators: No (unless you will do direct manipulation of data or import into specific programs, like Excel, etc.)

To transfer data I always use on the export all settings set to No;
for the import, log into the correct package combination, specify the company number and I use (BaanIV)
Delete existing tables: Yes
Create Rows before index: Yes
Ignore ref. integrity: Yes (you need to reorganize the data afterwards - Baan will start the session, you just have to fill in the company nr.).

Dear Victor,

Thanx a lot. You were really helpful.

Regards

Dheeraj