locked
Save view from database, separately and update it. RRS feed

  • Question

  • Hello, 

    I am tasked to create a dashboard that will use data from Database.

    I was told that instead of using Main DB, I should use view to collect data I need and store it on separate server and update in every some amount of time.

    I have experience of writing queries and scripts. But my knowledge in DB to DB data transfers in lacking. 

    Is it even possible and how would it work if it is?

    thanks.

    Wednesday, March 2, 2016 8:36 AM

Answers

All replies