How can I create an Entity Data Model in Visual Studio 2008 that includes separate databases from different SQL Server servers, which are hosted in different locations?
There is one server hosted locally and another server which is hosted by a third party vendor. We have full control of the local server, however we have only limited control of the hosted server, which is primarily used for reporting. The local server houses information that isn't tracked in the vendor's application, but is related to it from a business perspective.
I'd like to create a single data model for pulling data from both machines. Is this possible and how would I do it?