Hi,
I have a question about how to upgrade a NAV tenant to new version. Tenant versions are 2014 and 2015.
I need to run the data upgrade toolkit on the tenant DB, to make sure new tables and fields is published with correct data. What about obsolete tables, can the process delete these tables automatic?
But what is the process? And how to I optimize the task to be as quick as possible ( I have about 30 tenant DB's to upgrade).
Thank you.
//Mads
*This post is locked for comments
Sync will execute functions with type "TableSyncSetup"
Generally it is used to copy data from master tables to Temp tables.
Tools-->Dataupgrade-->Start will execute functions with Type UpgradePerCompany/UpgradePerDatabase etc.
generally these are used to copy data from temp tables to master tables with diff. field no. etc.
Please go through this video
if you look at Upgrade codeunit then code will be there to move data from old field to new file din table 204.
If you don't have any those kind of changes in your customizations then you can sync and mount tenant. Data will be moved properly.
Hi again Mohana,
You don't quite answer my question, so I'll try to describe my situation.
I have NAV multitenant solution running with multiple tenants on version 2015 CU 4. I want to move them to new server and NAV 2016 CU1.
I have a server I run as a middle station between old and new NAV server.
On middle server I have NAV 2016 Cu1 running multitenancy, and with upgrade objects in database.
Only modifications are reports no table modifications.
My plan is to do the following:
1: Dismount and back up tenant db on old server
2: Restore db on middle station server
3: Mount and Upgrade tenant db
4: Dismount and backup tenant db and restore on new server
So what do I do in number 3?
When I mount and try to run dataupgrade, I get meassage that I cannot do that because version of db is older than app database. Only option is to run Sync-Navtenant and then upgrade.
I have tried that approach to do Sync (without force), then upgrade. And data seems to be moved correctly from/to old obsolete fileds to new fields.
I am just pulsed why this works. Would the sync not throw away old data, so my dataupgrade do not have anything to move?
I have testet with table 204 Unit of measure. In DK local version we had a field containing the data which is now in standard W1 as field id 3 - International unitcode. The old field data is moved correct to new field.
Thanks
//Mads
It wont move data to standard field.
you have to write code in upgrade codeunit to move data from custom field to standard field.
before that you have to store the data in a temp table, if your latest version of object didn't have custom field.
Don't use force option ever. it will delete the data in deleted fields
Hi,
I have the standard NAV 2016 DB with imported upgrade objects. It is used as a multitenant APP database. Service is running fine.
Now I take my 2015 tenant and mount. When I try dataupgrade it says, that database is not upgraded, so I need to run sync-navtenant.
I can do that and then run dataupgrade, but will that work? Example in table Unit of meassure i have a danish field, which is now standard. But will sync not just delete old field, and create new without moving data ind dataupgrade toolkit?
//Mads
first create a test environment and then perform below steps
1. you have to merge the changes done in NAV2015 to NAV2016.
2. Prepare a final set of NAV2016 objects (we have to manually delete obsolete tables)
3. Import Upgrade toolkit from NAV2016 DVD
4. Above steps should be performed only when single tenant is mounted to application.
5. try to sync the tenant. if there are any sync issues then you have to solve in the upgrade codeunit or create a new upgrade codeunit as per your customizations if required.
6. if you can sync one tenant means all remaining tenants can be synched without any problem.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (