Does anyone know if Navision has posted instructions, tips etc. for designing navision databases for SQL server ??? Or does anyone have instructions on this matter, help would be GREATLY appreciated…
What kind of information are you looking for? There is some useful information in the Application Designers Guide that ships with the product. This will be extended and improved with the up-comming 3.01B version. This will be info such as how to best design indexes (e.g. the importance of field cardinality), SIFT information, information about the driver that Attain is using for SQL access, optimizations that are in place in this driver, and how to best exploit them in C/AL.