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?
LVL 8
pzozulkaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperCommented:
Will they allow you SELECT access on the cloud server?  Is the database schema changing at all ?  Will they allow connection over ODBC ?

These are a few questions that would impact your ability to connect SSRS to a new datasource.

In terms of preserving -- if they are leaving the current data where it currently resides, you should be able to continue to get those reports... however, the data won't be updated.  They will just be "historical" in that sense.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pzozulkaAuthor Commented:
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?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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?
Yes it is but your vendor will need to provide the necessary information for you change the connection properties.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.