Perform database upgrade for multiple databases by script
Hi all,
I'm aware of the database upgrade requirements and procedure as described below:
https://blog.devolutions.net/2018/04/remote-desktop-manager-basics-database-upgrade-steps
I'm now going to test the newest version of RDM 2020.2.12.0 , and as the release notes https://remotedesktopmanager.com/release-notes specify, I've upgraded our teams database.
However, we have multiple teams in our organization, each one has their own datasource (= database) on some shared SQL servers for this application.
Is it possible to somehow make the database upgrade 'external' to RDM, ideally by extracting or downloading the database upgrade script, so we can run it from the SQL server itself, against all databases we have on that server.
This way we can centrally upgrade all databases and prevent users who have upgraded their RDM client from the prompt to upgrade the database? sometimes they don't have the rights in SQL to update the database.
Also, maybe another note, but I wonder what happens if we upgrade the database too soon, for a new version of RDM it may require new database schema, but is it always backwards compatible, so can 'older' RDM versions still connect to an upgraded database.
Regards, Ben van Zanten
All Comments (3)
What RDM version are you currently running? Are all the databases at the same version? Can you send us database schema of your RDM (File > Data Sources > Edit > Upgrade (tab) > Send Schema to support)? Please add "Attn: Stefane" in the message body, I will get it faster this way.
The reason I ask is we sometimes have "code-base" upgrades steps that are not purely simple SQL statements. We haven't had any of those in a while but I just want to be sure your databases are OK for a manual upgrade.
Once I can confirm that you can be manually upgraded I will supply your upgrades scripts via a private message.
Best regards,
Stéfane Lavergne
Hi Stefane
Thanks for your quick reply!, wow that was quick.
I've upgraded my workstation to the newest, v 2020.2.12.0 but we're running mixed versions elsewhere: 2020.1.20.0 on other workstations for my team mates, v2019.2.24.0 on our management servers, etc. and other teams in our company will run even older versions.
And other teams databases are definately other versions, probably different versions for different teams since one team will have upgraded their clients earlier than other teams.
so that is part of the reason for asking, in theory we'd like to upgrade all databases in parallel if possible.
I've just send our DB scheme as you asked, but of course, that is 'our' database. As 'RDM application owner' i have to SQL access to the schema/database of other teams. that is why I was hoping to get some generic upgrade scripts we can send to the SQL DBA's to upgrade all of our databases.
Don't mind to continue the conversation via private messages, my email address is in my profile and in the schema just sent.
Regards, Ben van Zanten
Hi Stefane
We're now on the verge of upgrading from 2020.3.27.0 to 2021.1.21.0 the database needs to be upgraded from 669 -> 682 on multiple databases.
Can you create an upgrade script for me?
or do you once again need to have a schema, and from all databases, because we have multiple...
Regards, Ben van Zanten