Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Dynamics NAV 7 Programming Cookbook

You're reading from   Microsoft Dynamics NAV 7 Programming Cookbook Learn to customize, integrate and administer NAV 7 using practical, hands-on recipes

Arrow left icon
Product type Paperback
Published in Sep 2013
Publisher Packt
ISBN-13 9781849689106
Length 312 pages
Edition 2nd Edition
Languages
Arrow right icon
Toc

Table of Contents (20) Chapters Close

Microsoft Dynamics NAV 7 Programming Cookbook
Credits
About the Author
About the Reviewers
Acknowledgements
www.PacktPub.com
Preface
1. String, Dates, and Other Data Types FREE CHAPTER 2. General Development 3. Working with Tables, Records, and Queries 4. Designing Pages 5. Report Design 6. Diagnosing Code Problems 7. Roles and Security 8. Leveraging Microsoft Office 9. OS Interaction 10. Integration 11. Working with the SQL Server 12. NAV Server Administration Index

Testing the NAV database


For any system, consistency of data is very important. NAV provides tool to verify consistency. In this recipe, we will see how to run that tool.

How to do it...

  1. Open Microsoft Dynamics NAV 2013 Development Environment.

  2. Navigate to File | Database | Test Database. Your system will present a window similar to the one shown in the following screenshot:

  3. Select the option Maximum and then the second tab Options.

  4. From the Options tab, select the option File and provide a location to save the logfile.

  5. Click on OK to start the test.

How it works...

This tool verifies the consistency of data, so it is very important and viable to run this tool on a periodical basis. If we have huge data, then executing this tool on the Maximum setting will take a huge amount of time. Lets take a look at the task executed in the Maximum test.

Setting

Feature tested

Test primary keys and data

  • All records of all tables can be read

  • Record sorting order as per the primary key

  • Field data and data...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime