Testing to go Live - Need to know best way...[solved]
JAYESH
Member Posts: 290
Hi Experts,
I am ready to give my system to User for Testing Purpose.
Can any one tell me what is the best way to go from Test to Live database.
My Question is Which is the best way to Cleanup the Data from Navision.
Is there any Codeunit is there who clean up the Data from the Table ??
The some of the table like Item, Vendor, Customer etc will be same so NO changes in that tables..
So any one tell me or give me the List which tables will i have to delete from Navision..
Thank you
I am ready to give my system to User for Testing Purpose.
Can any one tell me what is the best way to go from Test to Live database.
My Question is Which is the best way to Cleanup the Data from Navision.
Is there any Codeunit is there who clean up the Data from the Table ??
The some of the table like Item, Vendor, Customer etc will be same so NO changes in that tables..
So any one tell me or give me the List which tables will i have to delete from Navision..
Thank you
JAYESH PATEL
0
Comments
-
The way I usually do this is to go to see all the data I've populated ( go to Database -> Information -> Tables and filter on No Records > 0 ).
Cut and paste this into excel.
When you get the database back from the user, find the tables which have grown. Be sure to double check all of them -- sometimes there are setups that you forgot that the user put in.
Delete what remains. Codeunit 8604 Data Cleaning does a lot of this for you, but you will have to modify it for the tables you actually need to delete.0 -
Hi Girish..
Thanks..JAYESH PATEL0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions