Migrate RDM to new SQL Server

I would simply try the following procedure:

you can go back to the original on SQL 2008 if you encounter problems, if all is well, decommission the old one.
regards, Ben

Hello,

Thanks @Ben05, it sums it up pretty well.

Make sure that when you backup the database you select the "Copy-only backup" option.
I would also create the logins before restoring the database, I believe that users will be linked to logins automatically.

This will work well assuming you're using database accounts. Also, if those database account are linked to a domain, it's important your new SQL-S is on that same domain.

If you plan to change the way users are logging into the data source, make sure they all export their private vault entries, and their user specific settings.

Let us know if you encounter issues


Best regards,

@Beno05, @Alexandre Belisle

thank you! it worked like a charm.

Hello,

You're very welcome, thanks for the feedback.


Best regards,