Would RDM9 client be compatible with RDM 11 DLZ/DB?

Hello John,
It will be compatible as long as you don't create or edit an entry.

The problem is that the structure of the XML evolve and you could loose some setting not known in the old version. However for a transition it will work.

to confirm, if I install RDM 11x, and it wants to "upgrade the database schema" that most 10x clients use, if I add an entry via an 11x client, only the delta between the schema is ignored, or the whole entry is ignored?

I understand the new features will go ignored by older clients, but as long as its only the differences not the entire entry/session in the db, this would be good to know.

It could crash the load of the new entry in RDM 10 if some properties are missing. Just make sure to backup everything anyway.

so, saying that. a gentle rollout upgrade is pretty rough. everyone needs to flip the switch almost at the same time.

If you modify or create sessions using v11 yes v10 users may have those sessions "disappear" from the tree view due incompatibility issues.

To help you roll out the new version you can use the Version Management features of the data source:

http://help.remotedesktopmanager.com/index.html?administration_datasourcesettings.htm#versionmanagement

I'm pretty familar with the version management. however, having the new or updated by 11x session not appear is better than "crash".

It will "crash" but silently. The system will not kick out, it catches the error and logs it for diagnostic purposes.

Hi Guys, thanks for the feedback,

Just want to confirm the steps for upgrade
1. Upgrade RDM client to 11 and open run it as Administrator
2. Open up Remote Desktop Manager Server console
3. Click "Upgrade Server"
4. Wait for it to finish
5. Upgrade the remaining RDM 9 clients

Do we need to upgrade DB separately or its all done in step 3 automatically?

The database upgrade is executed in the step 3.

Hi David,


The upgrade failed with the error message below. I have emailed the schema to support. Can you please assist?



A more detailed description
ERROR:System.Data.SqlClient.SqlException (0x80131904): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.UserSecurity' and the index name 'UIX_UserSecurity_Name'. The duplicate key value is ().
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbConnection dbConnection, IDbDataParameter[] parameters, Int32 commandTimeout)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteScript(String script, IDbConnection connection)
at Devolutions.RemoteDesktopManager.Business.DatabaseUpgradeAction.Execute(DatabaseConnectionDataSource dataSource)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.Upgrade(Boolean silent, LogMessageDelegate logMessage)
Error!
Restoring the configuration...Done!
Restoring the custom folders...Done!
Upgrade completed [1 error(s)]!


Thanks.


Kind Regards,
John

I will forward this to our DBA and he will help you.

Thanks!

@John - You have duplicates in the dbo.UserSecurity table. Usually, in this situation, we have one of our support team members connect and help you figure out which one of the duplicates to delete so that you don't loose private vault and user overrides. Until we can get you that session we have a work around for you. I will send it via private message. Why private? I don't want anyone randomly executing the steps and causing more issues.

Best regards,