[ Download ] Epicor 10.2 & Kinetic .CHM Schema

I can write a post about it… In a Nutshell the SSRS was simple I used Apex SQL Doc. But when it comes to the Database - tools like Apex/RedGate read the MS_Description property which is a metadata column in SQL and Epicors database does not have those set, so I wrote a Script that sets them by reading from their ZDataTable Table. Once you have set them, then you can use again any SQL Doc tool out there.

You can get the Trial of Apex or RedGate and give it a try see which one you like SQL Database documentation tool | ApexSQL
Database Documentation Generator For SQL Server | SQL Doc

So In Simple Terms, Yes it will pickup _UD Tables and Columns.


4 Likes