Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Object sizes different between two databases
Mauddib
Member Posts: 269
Weird one here if anyone has ideas? feel free to skip the background section and skip right to the issue:
=========================
Background
We have Navision 5 executables running on a 3.60 database on SQL 2005.
We have a test environment and a live environment. Both were restored from the same back up.
Normal procedure is to modify objects in test, and import them into live when ready.
Periodically we backup a company in our Live and restore into Test.
=========================
Issue:
Recently a lot of the objects in Live are smaller than in Test. There are tables and forms but mostly reports. For this reason a backup of data from live into test will no longer restore into test!!!
If I compile the live object it returns to the normal size!!!
No functionality has been lost and no other problems have been seen. This is solely a problem with backup and restore.
The objects with this problem are standard as well as customised, so its not connected to customisations.
Any thoughts anyone?
=========================
Background
We have Navision 5 executables running on a 3.60 database on SQL 2005.
We have a test environment and a live environment. Both were restored from the same back up.
Normal procedure is to modify objects in test, and import them into live when ready.
Periodically we backup a company in our Live and restore into Test.
=========================
Issue:
Recently a lot of the objects in Live are smaller than in Test. There are tables and forms but mostly reports. For this reason a backup of data from live into test will no longer restore into test!!!
If I compile the live object it returns to the normal size!!!
No functionality has been lost and no other problems have been seen. This is solely a problem with backup and restore.
The objects with this problem are standard as well as customised, so its not connected to customisations.
Any thoughts anyone?
0
Comments
The size of an object is something that can change by just compiling it even if you didn't change the object.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
These objects were never compiled or even designed to look at their code. They just changed size all on their own it seems.
Fastest would be a SQL-backup.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Its for our test environment we take Navision backups. We periodically take one of the companies out of our Live system and restore it into our test system to bring that company up to date.
Its this restore thats failing based on the recent unusual change in size of our live objects.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!