search

BigJames / reportsync

Automatically exported from code.google.com/p/reportsync
0 stars 0 forks source link

The reports migrate fine, but I lose the data source within the report. #39

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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