Hello there
Please I need to know How to obtain the database schemas for Microsoft Dynamics RMS, and if there is a useful SQL query to use it in custom reports
BR
Hi Ahmed,
Thank you for posting your database schema question; and thank you Ken, Kevin and Mark for assisting.
You should be able to run the below query to obtain the database schema:
select schema_name(tab.schema_id) as schema_name,
tab.name as table_name,
col.column_id,
col.name as column_name,
t.name as data_type,
col.max_length,
col.precision
from sys.tables as tab
inner join sys.columns as col
on tab.object_id = col.object_id
left join sys.types as t
on col.user_type_id = t.user_type_id
order by schema_name,
table_name,
column_name;
_______________________________________________
Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:
support.microsoft.com/.../search
This is less than 9 months from now; and you can continue using RMS after this date but technical support will not be available.
I would recommend checking with your partner in regard to what they may recommend as a replacement system after the extended support end date.
Thank you in advance.
It sounds like you want to create custom reports without any knowledge of the tables and how they relate to each other? This would be a major time consuming task on your part. Your best bet would be to contact a partner to either train you or create the reports. We can help with that if you are not able to contact or find your partner.
Not sure how accurate this is: static.austinhartzheim.me/.../microsoft-rms-database-structure.pdf You can also access your CustomerSource Account or request Db schema information via your Dynamics RMS Partner/VAR/reseller.
You have posted in the wrong forum. This forum is for the Dynamics augmented reality product called "Guides". https://docs.microsoft.com/en-us/dynamics365/mixed-reality/guides/
This forum has nothing to do with manuals or guides related to Dynamics 365. You need to post in the Dynamics Retail Management System forum for your answer.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154