Can someone give me a quick overview on the DB’s used by SSRS?
During a new install of 10.2.300, I created two Apps, each with their own DB. During the App Configuration, I set the Report Database Name, specific to the App. Resulting two apps:
App DEM_102300 (the Epicor Demo app and DB)
DB: DEM_102300
SSRS Report Server Name: RPT_DEM_102030
App TST_102300 (a blank Epicor install for testing)
DB: TST_102300
SSRS Report Server Name: RPT_TST_102030
In SQL Server Mng Studio, I see 4 DB’s related to SSRS
ReportServer
ReportServerTempDB
RPT_DEM_102300
RPT_TST_102300
What do ReportServer, and ReportServerTempDB do?
Is it normal to have “one” set of those? Or should there be ones for each specific App?
These belong to SSRS, this is where your Settings are, Execution Logs, Security Settings etc… You will have 1
ReportServer
ReportServerTempDB
Then Epicor will create a Database per Environment where it will house Table_GUID tables, that becomes your DataSet… in a rdl you are never reading from your original Epicor Database.
Let’s say you Print Job Traveler (do a Print Preview), Epicor will run their Internal Process App to get you all the data you need and INSERT it into RPT_DEM_102300 and then RDL will read from that, meanwhile the ReportServer will write down Execution Data, who Printed what, How long it took etc…
The RDL’s used by an App are in the report database specified during the App configuration?
In my 10.1.400 setup I had two Apps (Prod, and Test), each with their own DB, but they “shared” a DB for SSRS. And with is setup, I could make changes to an RDL and those changes would be seen regardless of Prod or Test (assuming both had the same RDL in the Report style)
But by specifying different DB’s, Changes to a report made in test, would need to be exported from Test, then imported into Production. Correct?