Background:
Our current SSRS 2008r2 installation stores all data sources in a separate
folder called, Data Sources, to prevent duplication of the same data source
under a different name. We have 18 folders under the Home folder. Each of
these folders houses reports based on business function. Security is set up at
the folder level, so users only see the folders they have access to.
I need to migrate our current install to a new server running Windows 2012 and
SSRS 2012, including the shared data sources and subscriptions.
I have created the Data Sources folder and shared data sources on the new
server, pointed at the correct server and database. The data source name is the
same on both the source and destination server. The Data Sources folder is
Hidden.
What steps will reproduce the problem?
1. Entered the URL to the Source Server. Then entered the User and Password.
2. Clicked Load on the Source Server and waited for the process to complete
3. Entered the URL for the Destination Server. Entered the User and Password.
4. Clicked Load on the Destination Server and waited for the process to complete
5. Clicked Tools, Map Data sources. Reviewed the default selections. They
were correct,so I clicked Set. (Example:Source = SRSReportUtilityReporting,
Destination = /Data Sources/SRSReportUtilityReporting)
6. Selected one report from the Source Server.
7. Clicked on the Folder I wanted to use as the destination on the Destination
Server.
8. Set the Local Path to a subdirectory on my C: drive
9. Clicked Download. Waited for the report to download.
10. Clicked Upload. Waited for the report to upload to the new server.
11. When the Upload Option did not work as expected, I tried the "Sync" option.
What is the expected output? What do you see instead?
1. Upload and Sync options garnered the same results: I expected to see the
report on the new server in the selected folder with the associated shared data
source. Unfortunately, just the report came over with no refrence to the
shared data source. The standard message, "The shared data source reference is
no longer valid" appears next to the Browse button in the Data Sources tab for
the shared data. In addition, there is no Custom Data Source set up.
What version of the product are you using? On what operating system? ReportSync
Version: 1.1.2.3331
Operating System:
1. Windows 2012 on the Destination Server.
2. The desktop I'm running the ReportSync application from is running Windows 7
Enterprise.
Please provide any additional information below.
Questions:
1. What am I doing wrong?
2. Should I be running this application on the new server?
3. When will report subscriptions be supported? I have approximately 150 I
need to migrate as part of this project. I would be happy to beta test this
functionality for you.
4. Is this scenario, not supported?
Thanks and have a great day,
Carol
Original issue reported on code.google.com by cagrotheer@gmail.com on 20 Dec 2013 at 6:12
Original issue reported on code.google.com by
cagrotheer@gmail.comon 20 Dec 2013 at 6:12