Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
SQL restore problem
zeon
Member Posts: 130
We are trying to to migrate from native 5.0 SP1 to SQL Server 2008. We took a backup of the live database and did the following
1) Restored the FBK as FDB on a test environment
2) Ran a full database test
3) Used migrate.fob from Upgrade toolkit and made all necessary corrections to make the DB SQL Ready
4) Took a fresh fbk of the database
5) Created a blank SQL database
6) Tried restoring the "SQL Readied" fbk
After restore completes we get the following error:
You cannot delete or change type for the field Pay Base (in table G/L Account), before the value in the field is reduced to zero or empty in all records. The message was shown, because there was found a value which is not zero in entry no.='2710' in company...
The field Pay Base which it complains about is a new field 50000 and it is a boolean field.
The backup we are trying to restore does only have one company, but the cronus company is loaded in the database as well.
The database is 5.0 and tech upgraded to 5.0 SP1.
1) Restored the FBK as FDB on a test environment
2) Ran a full database test
3) Used migrate.fob from Upgrade toolkit and made all necessary corrections to make the DB SQL Ready
4) Took a fresh fbk of the database
5) Created a blank SQL database
6) Tried restoring the "SQL Readied" fbk
After restore completes we get the following error:
You cannot delete or change type for the field Pay Base (in table G/L Account), before the value in the field is reduced to zero or empty in all records. The message was shown, because there was found a value which is not zero in entry no.='2710' in company...
The field Pay Base which it complains about is a new field 50000 and it is a boolean field.
The backup we are trying to restore does only have one company, but the cronus company is loaded in the database as well.
The database is 5.0 and tech upgraded to 5.0 SP1.
0
Comments
Two options
- Start with a new SQL database with NO objects in it and restore your whole fbk, not just the company data.
- Before you restore your company data use the object designer Import function on the fbk (treating it like a fob file) and import all the different objects with replace all.
Either should do the trick, the first will also get the data that's not attached to any one company (eg users and permissions).TVision Technology Ltd