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

Posted on 2012-08-20
Last Modified: 2012-08-20
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?
Question by:JeffEdmunds
    LVL 4

    Accepted 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.
    LVL 1

    Author Closing Comment

    Thanks for the quick reply!

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now