Navision Go-Live Tool

Administrator
Member, Moderator, Administrator Posts: 2,506
Navision Go-Live Tool
A utility to create a production database from a testing one by deleting transactional data.
http://www.mibuso.com/dlinfo.asp?FileID=580
Discuss this download here.
A utility to create a production database from a testing one by deleting transactional data.
http://www.mibuso.com/dlinfo.asp?FileID=580
Discuss this download here.
0
Comments
-
I don't think that this tool is usefull. Imagine you've forgotten to delete 1 table... I wish you good luck!0
-
I think, the problem is, that all tables are listed in the tool (Contacts, Customers, ...) instead only tables like 36, 37, 110, 111, and so onMany thanks, Roger0
-
I think this would be impractical, because localization, add-ons and custom development can introduce more transactional tables. Also, sometimes people want to delete some master data too, or sometimes keep some transactional data, f.e. typically Fixed Asset Ledger Entries of book value.
You can go through all the tables when you have some spare time, tick the ones you think should be deleted, and save it with a simple DataPort for later reuse. I think I will add that DataPort in the next version to save you the work.
If you are not very familiar with the table structure of Navision, here are a few hints:
- delete everything called "Entry", i.e. filter for *Entry*
- delete documents and journals - everything called "Header" or "Line"
- delete Document Dimension, Posted Document Dimension, Ledger Entry Dimension, Journal Line Dimension, although they are of course included in the aforementioned filters
Hope this helps,
Miklos0 -
Maybe you can incorporate this specs, you can add a column in the object designer "Existing Records". With this we can easily identity whether a table has records in it already.0
-
The problem I see with this is that you're deleting data [-X
It's certain that the users will discover that they wanted some of that data after all :roll:
What you should do is copy the data you want to keep to a new company let them do some little checks in the new company, change thier minds and mess things up.
So the final go live copy is right. That way we're all happy =D> =D> =D>
Of course a month after golive there will be yet another problem ](*,)
PS: Company.INSERT works just fine :shock:
PPS: Smiley overload \:D/Robert de Bath
TVision Technology Ltd0 -
This tool can be used as a start. But not necessarily run it out of the box.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Holy cow... I just realized I made it 10 years ago. Time is going fast. And almost 4000 downloads... I see now it is not the ideal solution to the problem but neither is the opposite i.e. just copying setup tables. But there wasn't one ideal solution in 2016. In 2016 the ideal solution is the copy company too. Set up everything in an empty database, copy it and make test postings in the copy. Change settings in the original, copy again, test it in that etc.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