migration 2.60 to 4.0 SP1

hazem
Member Posts: 187
Hello,
we made a database migration from the version 2.60 to the 4.0 SP1. Now, The problem is that the information contained in the database in v2.60 has changed during the migration process, and reinserting it in the new one is not the right way i think :x So we decided to import the FOB file containing all objects of database in the new vesion 4.0 (after migration) into the original database (of v2.60) in order to maintain the current information, stored in the database. BUT there are a lot of errors such us unknown variables... How should i proceed? :-k
we made a database migration from the version 2.60 to the 4.0 SP1. Now, The problem is that the information contained in the database in v2.60 has changed during the migration process, and reinserting it in the new one is not the right way i think :x So we decided to import the FOB file containing all objects of database in the new vesion 4.0 (after migration) into the original database (of v2.60) in order to maintain the current information, stored in the database. BUT there are a lot of errors such us unknown variables... How should i proceed? :-k
0
Comments
-
If I understand it correctly, during the upgrade process (=upgrading the data), users continued working on the old DB?
When doing the upgrade process of the data, they shouldn't work, because the things they did will be lost.
Once you start the process:
-customer stops working
-make a backup of the data
-do the upgrade
-do some checks to see if the upgrade went well
-install the new DB and users only start to work at that moment and with the new version.
BTW: some tables have been changed a lot between 2.60 and 4.00. So you just can't import a 4.0 fob in a 2.60 DB. Also because 4.00 has new commands that 2.60 doesn't know.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
All right,i think the error is that they continued working on the DB during the migration. So if i understand,the only way to use the current information with the migrated database is to reinsert ALL of it, which is "impossible"!!0
-
Final upgrade is done during weekend. During which time they do no make any changes to the database. Otherwise they have to reenter the data in new version.0
-
here's the steps for the migration:
1 - stop using the 'old' system for ever!! nobody gets to use it anymore until eternity.
2 - convert the data and create the 'new' one. I'm skipping all the work steps. During this time nobody, I repeat, NOBODY, does ANY kind of transaction in ANY of the two systems. NOBODY gets to use either one of the systems during this time
3 - start using the 'new' system only.
This simply takes time, but must be done if you want to do it right.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions