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

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

sql problem

(0) ShareShare
ReportReport
Posted on by 426

good day all, i need some help. my client upgraded his rms sql to 2019 and the system is running slow. the server alone has the 2019 . is there a way to downgrade it back to 2008r2?

I have the same question (0)
  • huijij Profile Picture
    19,811 on at
    RE: sql problem

    As far as I know you can't downgrade major versions (like 2019 to 2008r2) of SQL Server in-place.

    Unless the version is downgraded (e.g. Enterprise to Standard).

    regards

  • Community Member Profile Picture
    on at
    RE: sql problem

    Hello,
    There are a few ways to do it as part of a query, but they are all pretty terrible - mysql pivot is really, really not the right tool to do the job.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,069 Most Valuable Professional on at
    RE: sql problem

    Hi Alani

    With GP Power Tools, you could code this very easily.

    Regards

    David

  • kf5ydu Profile Picture
    30 on at
    RE: sql problem

    I generally will not upgrade sql instances and will create a new instance and restore a backup to that. With that being said there is no way to restore a database from a newer version of sql to even one version behind it. If you are dead set on doing that you can script out the database and then run the scripts to recreate it but that is not something I would even consider doing.

    I've run RMS with sql 2019 and before that 2017 and so on with no issues. Are you patched to 2.0.2023? If not I would start there and then I would work on optimizing sql and troubleshooting from there. Is SQL running on its own dedicated server/ computer? Does the operating system have at least 8GB of RAM? The sql buffer cache in sql express can only use 1GB, but I usually set the max memory to 2-4GB depending on the system. How large is your database and how many clients are accessing it? You may want to try setting up a new sql developer instance and if that performs better then go ahead and purchase a sql standard server/ cal or core license. Do not use sql dev in production or that can cost you greatly in an audit.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,828

#2
Sumit Singh Profile Picture

Sumit Singh 2,617

#3
YUN ZHU Profile Picture

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans