I need to migrate data in a BAAN 4C Oracle database to a BAAN 5 database on Oracle 8i. Do you need specific data migration tools to do this? If so are any provided in BAAN 5? Can I just use Oracle export/import? Has anyone done this? What is the easiest way to do this?

But as usual, that's probably not an option, right?

You definitely do not NEED data migration tools to do this. Unless Baan has changed their policy since the last time I did an upgrade, these tools are not provided with Baan and do not come for free.

Oracle import/export will work, but you need to map out what you want to load where. Most tables are significantly different between the two versions.

Another option is using Baan Exchange. The advantage of using exchange is that you'll have the DAL functionality to slap you on the wrist when you are attempting a boo-boo.

Chat,

I am trying to do the same to create a test environment but I
haven't come that far till now, I hope there is someone out
there who has the tools to do so but I do not get any answers
on this post.

Hope you have more luck to find a solution, I am wondering
if Baan knows the consequenses from this shitty thing, if we
cannot test as administrators how can we recommend the
migration from B4c4 to 5.


Regards,
pasadena

I am not sure that Baan is recommending this upgrade just for the sake of upgrading, 'latest and greatest' reasons. You would need a very good functional / ROI reason for upgrading from Baan IV to V.

There does exist a tool, but only Certified Upgrade Consulting Companies have access to it, of which we are not one, so I cannot speak in detail of it. However, I have seen the documentation on it, and it is reasonable for it to require consulting to run. You must redefine your business processes through pilot room testing, and put the new parameters into the tool as you export the Baan IV data, so the data comes over how you would need it in the new company. The tool also requires you to move all of your 'transactional' data through to processed delivered sales orders, and other processes to eliminate transactional data. They also recommend archiving.

I won't mention the price tag, as I understand it will fluxuate greatly depending on who you get to do it. You will probably have a consultant on site, and the minimum is 6 months. I BELIEVE (do not quote me) that Full Scope is a migration partner.

Some are trying on their own, to varying degrees of success. If you choose to do so, you must do all your own data mapping, and the tables have changed a great deal. As mentioned above, you will need to do Pilot Room testing and develop new business procedures before you ever get to migrating the transactional data. You will also need a lot of patience.

I now that we have to change some business processes but I have a small dump (1GB) over here which contains operational
data as we use it now!! It is not intented to do an upgrade just
for the sake of "upgrading is better" but only to test what we can expect when moving to BAAN ERP, we are working with BAAN for almost 4 years now and we have a fine group of key users who can deal with the expected problems, I will and cannot afford the use of consultants only for a small test, the setup of complete data transactions in a test environment will take to much time from the key users, IT is not our core business so I have to do this on my own.

If you have the documentation I would appeciate if you could sent me that!!!

Regards,
Pasadena

Hi,

you should write a mail to migrationsolution@baan.com. I heard, that they offer to (test)migrate customers data on one of their own servers.

The migration software for IVc4 - 5.0c is available and works quite good. We did a couple of tests within the last 8 month.

I viewed the hard version of the documentation at a client site that was considering the purchase of the tool & services. I don't have a copy, sorry.

It did not have table mapping or such, just documentation on the upgrade sessions