April 10, 2017 at 9:09 am
Is there a tool to copy just the data sources from one server to another one? I used the Microsoft tool and it was missing the security options.
April 10, 2017 at 9:56 am
smitty-1088185 - Monday, April 10, 2017 9:09 AMIs there a tool to copy just the data sources from one server to another one? I used the Microsoft tool and it was missing the security options.
You can find Powershell scripts to do this - a few in Microsoft's Script Center. Here is one example - you can search around for others at that site:
Export of all SSRS reports datasources and resources
Sue
April 11, 2017 at 11:35 am
Sue_H - Monday, April 10, 2017 9:56 AMsmitty-1088185 - Monday, April 10, 2017 9:09 AMIs there a tool to copy just the data sources from one server to another one? I used the Microsoft tool and it was missing the security options.You can find Powershell scripts to do this - a few in Microsoft's Script Center. Here is one example - you can search around for others at that site:
Export of all SSRS reports datasources and resourcesSue
That's the script I used that didn't include the security settings after the export.
April 12, 2017 at 12:02 pm
smitty-1088185 - Tuesday, April 11, 2017 11:35 AMThat's the script I used that didn't include the security settings after the export.
SSRS encrypts credentials such as those set up with "Credentials Stored Security on the Report Server" so it's not going to include the user and password for the data sources. Otherwise there would be risks with anyone being able to read the user names, passwords in Catalog table in the ReportServer database.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply