Skip to main content

Notifications

Announcements

New Dynamics 365 Community Call! (ERP Edition)
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS forum / Export Store Database
Microsoft Dynamics RMS forum
Answered

Export Store Database

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

We have problem exporting store database from RMS (1006) and SQL 2012 64 working at Windows server 2008 Enterprise 64 sp2.

when try to create new store database, it just copy the template database with all fields like purchseorder and [transaction] even configuration (storeid). the you just another copy of your template.

now after restoring the sample HQ and store databases from "dbfiles" and do create new store and export, found the same problem.

the problem shows at the attached image when click ok, it should start scripting the template store and show progress bar. but when click ok it just show the next step and ignore scripting without any progress shown

.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export Store Database

    Hi , 

    RMS FP2 version is having a nasty bug when hosted in SQL2012.. No wonder MS always certifies a new SQL platform to use with RMS version and then let customer to suffer for months before releasing a patch. 

    Install CU5 and export the store database. They have fixed the bug in CU5 release.! 

    Moreover applying an update in RMS is a nightmare.. you have to apply it in all POS Systems...Imagine when you have around 200 POS systems!!

  • Mohammed ElQadi Profile Picture
    Mohammed ElQadi 130 on at
    RE: Export Store Database

    Hi,

    Just use SQL2008.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export Store Database

    Hi EkQadi, 

    Didn you find any solution for this ? We are facing exactly the same issue while exporting the database ? SQL 2012 is supported in RMS CU5 as per the tech notes but it doesn't work.  Template DB is not scripting instead it goes to next screen and start coping the template database data into new database.  any suggestions would be appreciated...

    Regards

    GA

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export Store Database

    you can also try mirroring DB/replication  to SQL 2012 if you REALLY need 2012.

    I would wait, RMS will phase out within 12 months to new stuff like cloud HQ @ MSFT direct...so no more problems with HQ infrastructure..

  • miguelgandia Profile Picture
    miguelgandia 5 on at
    RE: Export Store Database

    Hi Mohammed,

    I have this same error.  This was solved?  

    Regards,

    Miguel

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export Store Database

    Hi Jeff,

    Thanks, but I'm working with SQL2012 for over a month ago at my stores and didnot see any problem except the export, would you please till me about some of those problems that you faced to check that at my side.

    Thanks again

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: Export Store Database

    Well, they claim to support it now, but we've seen weird things happening, so we are not installing it on any of our client's machines right now.

    Sticking with Sk8R2.

    Since this appears to be a test machine or VM, should be easy enough to try with an earlier version

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export Store Database

    Hi Jeff,

    Thanks for your reply, but it this the only way?, how long do you think RMS will start support SQL2012?

    but they Microsoft did issue that it support SQL2012 for RMS2

    https://el3rod.com

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export Store Database

    Hi Ed,

    Thanks for your reply, I'm using 2.0.1006.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: Export Store Database

    Pretty sure this is a SQL2k12 issue.  Try backing down to SQL2k8.

    FWIW, we are holding off using SQL2k12 because of  weirdness issues.

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans