GroupName Table Invalid Key Column in an Index

GroupName Table Invalid Key Column in an Index

avatar
thashley
Disabled

Support,

We're looking to purchase the enterprise global license for RDM and a stepping stone for testing is getting a distributed database working for RDM. Our plan is to use Azure Databases with the Sync Database capabilities so that the "spoke" databases are what the users are connecting to regionally with a "hub" database that's the master of all. RDM requires read/write to open against a database so we decided this was the best way forward.

That said, we're having a few problems with setting up the sync databases within Azure, one of them being around the GroupName column under the dbo.ConnectionHistory table. It's set as an nVarChar(max) column and key column's within an index can't be more than 450 characters (900 bytes). Is there a specific reason this was set to max for GroupName? I noticed some of the other GroupName columns are set to nVarChar(256) (if not all...i didn't dig that far).

Any other advice is appreciate on how we can make this a distributed database so latency is at a minimum for our global colleagues.

Regards,
Terry

All Comments (1)

avatar

Hello,

Using database tools means that you will lose the logs.

Our current recommendation to achieve that hub and spoke architecture is to:







The downside of our recommended architecture means that you need a RDM installation that runs in the context of a logged-on user...

I know that you plan on using Azure, but for sake of completeness with this public post, I will add that with our Devolutions Password Server, a REST API is available, but we haven't written the scripts to showcase how to export data from the server.

Best regards,

Maurice