Skip to main content

Notifications

Microsoft Dynamics RMS forum
Answered

database schemas for Microsoft Dynamics RMS

Posted on by 5

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

  • Verified answer
    ToddB Profile Picture
    ToddB on at
    RE: database schemas for Microsoft Dynamics RMS

    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:

    community.dynamics.com/.../microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

    support.microsoft.com/.../search

    pastedimage1604587276906v1.png

    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.

  • mcons Profile Picture
    mcons 390 on at
    RE: database schemas for Microsoft Dynamics RMS

    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.

  • Kevin Antosh Profile Picture
    Kevin Antosh 1,645 on at
    RE: database schemas for Microsoft Dynamics RMS

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: database schemas for Microsoft Dynamics RMS

    Ahmed_Abdelkader,

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans