One of my clients is planning to convert from c3 to c4 and the size of their database is around 40GB. Does anyone have experience exporting/importing such a huge amount of data? They have SQL Server and WIndows.

Thanks.

40GB is a very small amount of data..

Also - If you're exporting and importing all 40GB then you're doing it wrong...

Dave

40GB is a very small amount of data..

Also - If you're exporting and importing all 40GB then you're doing it wrong...

Dave

I agree with both statements....

40 GB is not that much - I was on a project where we were growing at a rate of 200 GB every 6 months.....

also a 4c3 to 4c4 upgrade is not that big of deal and you should NOT be exporting the data! It should just be another VRC in your derivation structure...

We're just in the process of a c3 > c4 migration.

Our DB is about 70 GB and we're using the standard Baan sessions for creating sequential dumps and then creating tables from the sequential dumps in the new c4 VRC on our new server.

The whole process is expected to take from Thursday 5pm to Sunday 10am.

Regards
Neal Matthews
IT Support Analyst
ATY Automotive & Industrial Components (UK) Ltd

A) If you absolutely insist on doing SEQ dumps, make sure you use db_resource settings (ie. RDS_FULL=100) that will speed up the dump and also what I have done is "manually multithread" the SEQ dump by creating 7 seperate SEQ dump ranges and firing them all off at the same time. I can do about 30 GB in about 6 hours.

B) Please look at session ttaad1101m000 - Change Pkg Comb. by company
This session will evaluate the Data Dictionary differences between c3 & c4 and automatically do the table conversion for you on ONLY the tables that change between the 2 VRCs. Your message also stated you were going to a new server - you could do a "restore of Baan" on the new server and then just use this session to migrate. Our App & DB restore in about 5hrs.

Just another thought.. when migrating to c4 are you applying all 18 service packs too?

We are actually going from c3 sch0 to c4 ags0.

I don't think a direct restore would work as we have a different disk setup on the server.

We did a bulk install up to SP12 (I think) and then did 13,14 and 15.

Thanks for your input.

Cheers
Neal

ah - I see you are on Informix...

If you plan to reconfigure your inf_storage file and changing how you have the database files structured, then I can see needing to do SEQ dumps. However, I assume that you are not planning to do a SEQ load directly into c4 ags0 because of the DD differences... which of course would fail on those changed tables...

The idea of "multiple simultaneous SEQ dumps" would still work for you and may accelerate your process!

Correct we have to migrate from c3 sch0 to c4 sch1 and then c4 ags0.

We don't really have a problem with the down time as the factory will be on shutdown when we do the migration so we never really thought about doing multiple seq dumps. Although it's very useful to know that this can be done.

Cheers
Neal

sounds good... if you were already shutting down the plant - but if you are shutting down the plant because of the Baan conversion, I think you have opprtunity here for it to take less time.

Our customers like a good long break which is ideal for IT projects but not good for our own holidays.

Cheers
Neal

Maneesh,

Run ttaad4226m000 for seq dump (select specific separators & directory for tables files check box) from old server & import using ttaad4227m000 on new server.
if u can change db_resourc file setting on both the server then it will save ur 50% time easily. pls go thru the file (file to store table name error not created) & event viewer during importing. use batch installer (sp1-18) for sps loading. definitly some tables may be skiped due to structure difference.

please feel free to contact me for any query regarding to said topic.

best of luck.
bye

Anuraag is right you can do the same procedure through which you can save your lot of time also. Well 40 GB is not a large amount of data.