web
You’re offline. This is a read only version of the page.
close
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 GP (Archived) / SQL-Moving from Enterp...
Microsoft Dynamics GP (Archived)

SQL-Moving from Enterprise Edition to Standard is there any issue?

(0) ShareShare
ReportReport
Posted on by sandipdjadhav 18,306

Hello,

Is there any problem if client currently using 'SQL Server Enterprise' and now want to move to Standard Version of SQL Server is there any issue while restoring DB to new SQL Server i.e. Std version? 

Your earliest reply is highly appreciable.

Thanks much

Sandip

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    When we switched from Enterprise to Standard we had to uninstall and reinstall Management Reporter.  A simple restore did not work for Management Reporter.  We did not have any other major issues that I remember.  It has been a couple of years.  We are running SQL Server 2014.

    Keith McConnell

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Sandip,

    There is no major issues to expect by downsizing from the 'Enterprise' edition to the Standard edition.. We did this a few years ago by moving at the same time from SQL 2005 to 2008.

    The issue Keith reported was more likely linked to the fact that the SQL server changed name during the process and yes, due to the encryption key that is used when setting up MR 2012, you have to reset this..

    Mariano Gomez has a blog post related to this and it's not a bid deal, but you have to remember about it, before banging your head against the wall :-).

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Thanks all for your reply. I have suggested same to client.

    Thanks much

  • Kumar_Sat Profile Picture
    Kumar_Sat 1,282 on at

    Hi Sandip,

    I did it about 4 months back. It is the same standard process as if you are installing a new server. Yes, the MR did not work as highlighted above but you can have all the reports exported and imported back and it would be fine. I was able to do it in 2 hours for 5 company database.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans