Also I'm wondering, if the DB is getting full and thats why is unresponsive should we forward all the data to a new DB to prevent that one to keep on growing?
1 of 1 people found this helpful
Answer 1: I don't think that will work. 1 ePO with 2 CSR servers.
Answer 2: Looks like your premise was based on #1 being possible, which it isnt.
Answer 3: No, In theory you could copy the DB, point a 2nd CSR (with 2nd ePO) at the copy, then delete half the data using DB maintenance.
To point CSR to a different DB, you only need to modify the DB under the Report Server settings (first screenshot in the doc) and then restart the CSR service. The Database settings under the registered servers will be updated automatically when you restart the CSR service.
EDIT: to "migrate" your existing DB, follow these instructions
1) Take the DB offline under the report server settings.
2) Move the DB according to microsofts instructions
3) Set the new DB address under the report server settings, and put it back online
4) Restart CSR (the registered DB address should update automatically)
Message was edited by: sroering on 3/5/14 5:05:12 PM CST
Thanks for your reply, very useful as always; just realized on the CSR server there is no mysql client by default so I cant enter into the shell. Im downloading a toolset right now.
Another question by the way; if the original DB was created with the CSR Installation Wizard this will crate a mysqlDB type. If I want to use SQL Server ( Microsoft type ) DB, is there any way to export the data from Mysql to Microsoft SQL ?
Thanks for that
according to your screenshots, you are using an external Microsoft SQL database, not MySQL. So the internal MySQL database isn't being used. You could even disable the service if you wanted.
For using an external DB, you need to create the DB and user account for the connection. Then when CSR connects to the DB for the first time, it will create the table structure. But CSR doesn't create a mysqlDB type. The type depends on which DB you are connecting to. But to answer your question, no, there isn't any supported way of converting data between the two DB types. But it doesn't look like you are using MySQL, so I don't know where this question is coming from.