Migrate to Azure SQL
We are currently running our RDM database on Microsoft SQL 2008 R2.
We are looking at migrating to Azure SQL at some stage but after some testing, we noticed that we can't use our integrated AD accounts anymore, even though our Office 365 environment is synced with our on-prem.
Is there any other way for us to reconnect our users to use the new Azure SQL with Azure AD accounts without having to get recreate all the users, add them to roles and get them to back up their private vaults to be imported into their new account?
All Comments (3)
Hello,
Are you planning to move your database or to create a new database on SQL Azure?
Best regards,
Jeff Dagenais
Hi Jeff,
We will be hoping to move our database as that is the method we tested with and settings came with, Global entries, roles, users, etc. The only issue was that we couldn't use our original user accounts, thus losing the private store.
Hello,
Indeed, your users would need to be recreated since you will not use the same authentication method.
Your users would need to export their private vault into a .rdm file and then, import them again in RDM connected with their new account.
Best regards,
Jeff Dagenais