Restore into SQL2005 doesn't include Appl. Objects

Ricovski
Member Posts: 2
Hi people,
I have a funny situation; when performing an ENTIRE backup from a native database and trying to restore this backup into SQL, only the TableData and Tables are restored. Also, there is no option to select Application Objects on the restore form. When using the same backup file in another SQL installation or native database, everything is fine and I have the option to restore Application Objects or not.
The above points directly to SQL2005. Does anyone have an idea what the reason could be for not restoring Application Objects?
Many thanks,
Rico van Zyl
I have a funny situation; when performing an ENTIRE backup from a native database and trying to restore this backup into SQL, only the TableData and Tables are restored. Also, there is no option to select Application Objects on the restore form. When using the same backup file in another SQL installation or native database, everything is fine and I have the option to restore Application Objects or not.
The above points directly to SQL2005. Does anyone have an idea what the reason could be for not restoring Application Objects?
Many thanks,
Rico van Zyl
0
Comments
-
Probably it is because some object (not the standard Navision) already existed in the SQL2005-DB.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
You'll notice that when we do a restore, the restore application objects check box is not selected -- worse still, its uneditable. To do the full restore you first restore as usual, then, go to the object designed, and import all the application objects.
Why? I think its just a bug.0 -
girish.joshi wrote:You'll notice that when we do a restore, the restore application objects check box is not selected -- worse still, its uneditable. To do the full restore you first restore as usual, then, go to the object designed, and import all the application objects.
Why? I think its just a bug.
Open the object designer, select File=>Import and select the backup-file. Navision will then consider the .fbk-file as a normal .fob-file.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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