• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 685
  • Last Modified:

Create an Entity Data Model in Visual Studio 2008 which includes databases from different servers

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?
1 Solution
You can't do two separate databases in one EDMX. However, you can do two separate EDMXs in your application and your code logic accesses them both.
JeffEdmundsAuthor Commented:
Thanks for the quick reply!
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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now