what happens to company data when upgrading?

nostran

Hi,

the developers are currently working on the upgrade of a database 3.7, which contains different customised objects to 4.0.

when they do the conversion of the database 3.7, they are taking an clean 4.0 database and migrating the different changes from 3.7 to 4.0. which apparently works fine but the thing is that the "data" i.e. the company information is not to be found in upgraded database. They are saying that the data in 3.7 has to be exported to 4.0 using dataports.

Is that the correct way to do it? Personally i don't think that's the right way. Cause if we are taking one table at a time in the 3.7 database, exporting it and then importing into 4.0, what happens if the data type of a field has changed in the process?

If we do import balances at a cut off date, we will lose "comparative" figures that surely will not be acceptable for customer.

Your help would be most appreciated. I would be shell shocked if Navision does not have a tool for data conversion following an upgrade #-o

ngebhard

Hi!

Actually you do not need to transfer the data with dataports. You are supposed to customize the objects of V400, then open the V370-Backup in a V400-Client and do the upgrade process. There is an upgrade tool which helps you converting the Navision tables which has changed. There are a couple of steps to process i.e. importing the V400-objects.

Try to get the upgrade tool. I am not sure if this can be downloaded at mibuso.com but your MBS Partner might help you!

If there are any more questions: feel free to ask again! I will try to give more detailed information.

Regards
Nicole

Marije_Brummel

Hi,

I agree with Nicole, in fact, if this upgrade is done by a Solution Center I would consider changing! This is not the way to to an upgrade.

Look at this link

http://www.mibuso.com/forum/viewtopic.php?t=7155

The is a step by step manual which tells you how to upgrade.

ngebhard

I was searching for this link but didn't find it right away!
Thanks to Mark!

ecclectic

hi ngebhard

there's one thing that's not clear. how do u actually convert the actual data once the database objects have been upgraded, i.e. what do i need to do to be able to use my existing companies with my upgraded objects.

thanks

kine

ecclectic wrote:

hi ngebhard

there's one thing that's not clear. how do u actually convert the actual data once the database objects have been upgraded, i.e. what do i need to do to be able to use my existing companies with my upgraded objects.

thanks

All is in the upgrade steps... :-)

shortly:

1) Step 1 transfer all data from tables which are changed in new version to some temporary tables.
2) You import new customized objects
3) Step 2 transfer the data from temporary objects back to the new structure...

ecclectic

hi kine,

1)how do you transfer the data to temporary tables and what tools do you use?
2) how do you import the data from temp table and what tools do you use?
3) when importing data in new tables, what happens if data type, length of field has changed? how is the validation done

ngebhard

ecclectic wrote:

hi kine,

1)how do you transfer the data to temporary tables and what tools do you use?
2) how do you import the data from temp table and what tools do you use?
3) when importing data in new tables, what happens if data type, length of field has changed? how is the validation done

Hi ecclectic,

this steps are supported by the upgrade tool which can be downloaded at the link given. This tool is for the standard tables if some tables or fields doesn't exist any more or if something changed in what way ever.

For your own tables you're actually supposed to "freeze" the programming during an upgrade. If there's a need to change anything in the old version, you need to make the same change in the new version before upgrading. Changed fields should not be a problem if you behave like this.

Greetz
Nicole