You’re offline. This is a read only version of the page.
1,930
OK I was able to rebuild the database and migrate them to a new server - when importing the Building Blocks it imports as a list. For ex: the original database has reports organized in folders (10 folders with each folder having several reports) . But when the reports are imported it does not import folders names just a long list of reports.
Is there any way to import them with the same folder structure?
Also is there any way to import the users?
Thanks
You should migrate the whole database to a new server in order to keep the users and securities from the old server, you still need to recreate folders in Viewer if report output & distribution not to set to the default, then you need to point those reports in designer Output & Distribution tab to map to its Output Locations folder respectively. You need to reschedule reports if you had before. There are some works needed to be done even you bring the whole database to a new server but it will save your time.
Microsoft stopped enhancing MR so there are no more tools will be added, the import building blocks tool will be nice if it includes the choice to bring user, security, viewer folders and etc,. I thought about to use BCP to bring some tables from the old server but it takes time too.
I did many times as Michael did.
Hope Microsoft has an answer here.
Rob
I had the same problem and couldn't find a solution so I just wound up creating the folders and dragged & dropped the reports into each folder respectively. I also manually recreated the users and permissions.
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,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (