I have 3 SQL Server Databases in 3 Facilities. What I want to do is create a view in our Local SQL Server that Draws data from the other 2. Which I've done but I'm not sure I'm doing it correctly. What I have is a job that runs in the morning prior to people coming in that runs a query to create the data locally for the users to access. the queries take a few hours to run and the data is static for the day. I have a new request that needs the same type of data but it must be dynamic. My question is if I create a view that uses the off-site SQL Servers is the data continually updated during the day? Also will I have issues with the timing for that data. (If a user updates the data in the vendor supplied front end how long will it be until the data shows up in my View?
Any help is appreciated.