Skip to main content

Notifications

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) / RMS Migration to new h...
Microsoft Dynamics RMS (Archived)

RMS Migration to new hardware.

(0) ShareShare
ReportReport
Posted on by Chad Simmons 410

We are currently running Windows XP Pro and SQL Server Express 2005 with RMS build 2.0.1006. This is a single computer install. Database server and POS station are all on one machine. We will be upgrading to a Windows 7 Pro machine soon. I'm wondering if I can use the latest SQL Server Express package instead of the included 2005 package. Do I need to preinstall these packages prior to installing and updating RMS? Also is there a guide available for the packages I need to download and what order to install them in for both the SQL server and the RMS updates? I do have an active subscription to Customer Source. I think I understand the basics of backing up and recreating the database on the new machine. I don't know whether it will upgrade the database automatically on import or not. Thanks for any input.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: RMS Migration to new hardware.

    With POS open Press CTRL + F6, Press the window button and check the box "show resizable border".

  • Chad Simmons Profile Picture
    Chad Simmons 410 on at
    RE: RMS Migration to new hardware.

    Thanks for the input. Other than having to fight a bit with the SQL installation (it kept giving me errors trying to install the management studio so I had to install the server package with tools already built in) everything went well. I didn't even have to call to reactive the POS. The old code worked fine.

    I have one issue left though. The POS program opens fullscreen with no minimize controls. I'd prefer it windowed. Any way to fix this?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: RMS Migration to new hardware.

    Use SQL Server 2008 R2.  Stay away from 2012 even though MS says the latest CU5 patch supports it.  

    Install Sql Server,  Then Backward Compatibility Pack,  Then Management studio.  Enable Named Pipes and allow sql server through the firewall.  Make sure to use mixed mode authentication for sql server.  

    Then install all your opos drivers.  Use the same version that the old computer is using unless upgrading peripherals.  

    Lastly install RMS and patch to your version.  Test everything.  Then patch to newer versions if you need to.  

    database is upgraded under the Administrator program, manually.  You connect to the database and then choose database -> upgrade.  

    MAKE SURE TO HAVE A BACKUP, and batch all credit cards before moving the database in case you need to upgrade.  

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans