web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Imorting Data RMS DB
Microsoft Dynamics RMS (Archived)

Imorting Data RMS DB

(0) ShareShare
ReportReport
Posted on by Sudipta Sarkar 20

Dear All

Can you all, help me in importing external Sql DB data to RMS SQL DB. Although it's a e-commerce database but the schema structure are dissimilar. I want to import it into RMS structure. For example in my DB I have product table in I want to import it into Item table of RMS SQL DB. I have Size and Color table which I haven't find out in RMS DB. Please guide me how to proceed on that.One time import it's required for Customer Data, Inventory Data, and Order Data.

*This post is locked for comments

I have the same question (0)
  • Shawn Meade Profile Picture
    Shawn Meade on at

    Hello Sudipta,

    Unfortunately, the extra columns such as the color and size would not work to be imported into the item table.

    It is theoretically possible, but the point is that the rest of the database would not know how to read it, and you would be receiving a massive amount of errors if you did this.

    Store Operations allows for matrixes to be made which include the color and size, but these kind of attributes are not applied to all items.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans