Set-RDMCurrentDatasource -forcepromptanswer does not work
Hi!
I am using the Devolutions.PowerShell 2023.2.0.8 with an older MSSQL-Datasource. I don't wand/can upgrade the database yet. If I set the datasource I get this prompt
A database upgrade is required. If you don't upgrade, the data source will not be available. Data source name: my_datasource Current version: 809 Target version: 874 [] Yes [] No [?] Help
I tried to avoid this prompt with
Get-RDMDataSource -name my_datasource | Set-RDMCurrentDataSource -ForcePromptAnswer No
but it does not work.
All Comments (7)
Hello Timo,
You will need to use the same version of the module as the version of your data source. You cannot use a newer module version with an older database version. For example, if you use RDM 2021.2, you would need to use the 2021.2.x version of the module.
You can refer to the following to get the appropriate version:
- RDM (2022.3 and below) - https://www.powershellgallery.com/packages/RemoteDesktopManager/
- Devolutions.Powershell (2023.1 and above) - https://www.powershellgallery.com/packages/Devolutions.PowerShell/
Best regards,
Richard Boisvert
Hi!
That is not the point. I am aware of this. In my usecase (testing and reading access only) all works fine with the new modul on old database. But the point is: The -ForcePromptAnswer does not work.
CU,
Timo
Hello Timo,
I am validating with the PS module developer; we will get back to you.
Best regards,
Richard Boisvert
Hello Timo,
The developer confirmed it is a bug. He will work on fixing it, we will keep you posted.
Best regards,
Richard Boisvert
Hi Richard,
I'm running into the exact same issue which has become a big hurdle for our automation.
In addition to this, can your developer also create the capability to forceprompt multiple answers for the database upgrade?
For example:
Get-RDMDataSource -name my_datasource | Set-RDMCurrentDataSource -ForcePromptAnswer Yes, Automatic
Hello Rob,
I have notified the developer of your request.
Please note that we still recommend using the correct version of the Devolutions.PowerShell module for the initial issue.
Best regards,
Richard Boisvert
Hello,
A new version of the Devolutions.PowerShell module is now available with the fix for your issue: https://forum.devolutions.net/topics/40344/version-2023208-6th-october-2023
It is also possible to pass an array. To select Automatic mode, pass "Yes" as the option.
Best regards,
Richard Boisvert