Want to point view to new database

Chris shared this problem 11 months ago
Defect Fixed

We have spent several months building reports and views BUT client has changed some databases. We would like to point the views and reports to a new data base to save us the time recreating the views and reports.

Is there a way to modify the database that the views and reports point to without having to recreate all of the views and reports.

Comments (4)

photo
1

Hi Chris,

Thanks for reaching out. We have an option coming in 7.4.8 where there will be functionality in the right navigation panel of View Builder to point to a different data source.

Our approximate ETA for 7.4.8 as of right now is some time in December. I've added you to our client list of those being affected by this in our internal task and will provide an update for you here when we have an exact 7.4.8 publish date as well as when it's actually published.

Regards,

Mike

photo
1

You could reconfigure your database connection string and keep the same data source name.

photo
1

Hi Chris,

Indeed you can do as Alan's suggested here. I should have mentioned this is still possible in a more roundabout way and that a simpler UI option is forthcoming.

Our recommended method at this point in time is to:

Export the view, then import it over the top (to preserve linked objects) - at this point you can then change the data source.

Hopefully this info helps, but regardless I'll keep you posted on the UI solution that is being added in 7.4.8.

Regards,

Mike

photo
1

Hi Chris,

Just wanted to let you know that this task has now been completed and included in the latest 7.4.8 release.

You can download latest builds here.

Would love to get confirmation your issue has been resolved with the latest release, so please let me know how it all goes post update, and of course reach out if you have any questions on this.

Thanks,

Mike