asked on

SSRS: SQL reports migration

We are paying annually for user licenses to access a 3rd party application. The application has a database instance on our local in-house SQL server. The database instance is pretty much locked down, but they are allowing us SELECT privileges, so we were able to generate a lot of reports using SSRS.

We are now moving away from hosting the application and database in-house, and moving towards their (our 3rd party vendor) cloud solution. The application and database will be hosted by them. I'm 99.9% sure, we will have no control over the SQL server, and therefore will not be able to install SSRS.

Question:
Is it possible to preserve our SSRS server, and simply change the connection strings on all existing reports to point to the new SQL server in the cloud?

Any other ideas on how to preserve existing reports?

ASKER CERTIFIED SOLUTION

zephyr_hex (Megan)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pzozulka

ASKER

I'm assuming SELECT access will still be allowed, otherwise this is a non-starter. I will check on this.

Database schema is not changing.

Don't know if they will allow connections over ODBC.

Let's assume the answers are all YES, and we don't care about historic data, we need live data.

Any other ideas on how to preserve existing reports in the sense that they are now pointing to the new SQL server to get data?

SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial