91
Is there a way to extract rows from MR using SQL?
They found a backup of the old database and are asking me to retrieve building blocks that might be there from before a disgruntled manager wiped them out
They didn't have MR backups far enough back to get them in CU 16 and I don't think I can load a CU 15 MR db.
As Beat mentioned, there is no way to extract the building blocks from SQL. You'd want to restore the database and then export the building blocks. This blog will guide you through restoring the database and connecting to it:
You can download CU15 here:
https://docs.microsoft.com/en-us/dynamics/s-e/mr/mroverview_435
Scroll down to the Current Release Downloads section and then click the Previous Releases and Hotfixes link.
Hi Steve,
There is no easy way to extract that data from the MR database... not as I know of, and I've doing a lot of SQL queries for MR.
What I'd do is restore the MR backup that you have on CU15 to a different system (TEST or DEV environment), or even a local SQL Express would do it. Then retrieve the exact CU version that's defined in one of the MR tables (don't remember the exact name, but it's a table that only holds 2 rows (always)). Then install that exact same version, though any newer version of MR would do it and automatically upgrade the database.
Since the database was restored on a different server, you'll have to reset the Encryption key on the MR Database... search the forums here, there are old threads about that topic. Once you have a functional MR server working, you can access the data with MR Designer and export all building blocks with it.
HTH.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (