Databases
StackOverflow2013
Postsdbo
PO(hard question) how can I store specific rows of a table in a different sql server?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO(hard question) how can I store specific rows of a table in a different sql server?
    primarykey
    data
    text
    <p>I have a bit of an architecture problem here. Say I have two tables, <strong>Teacher</strong> and <strong>Student</strong>, both of them on separate servers. Since this tables share a lot of data and functionality, I would like to use <a href="http://www.sqlteam.com/article/implementing-table-inheritance-in-sql-server" rel="nofollow noreferrer">this inheritance scheme</a> and create a <strong>People</strong> table; however, I would need tho keep the <strong>Teacher</strong> table and the <strong>People</strong> records relating <strong>Teacher</strong> in one server, and the <strong>Student</strong> table and the <strong>People</strong> records relating <strong>Student</strong> in another server. This was a requirement made by the lead developer, since we have too many (and I mean too many) records for <strong>Teacher</strong> and <strong>Student</strong>, and a single database containing all of the People would collapse. Moreover, the clients <strong>NEED</strong> to have them on separate servers (sigh*).</p> <p>I would really like to implement the inheritance scheme, since a lot of the funcionality could be shared among the databases. Is there any possible way to do this? any other architecture that may suit this type of problem? I'm I just crazy?</p> <p>--- EDIT ---</p> <p>Ok, I don't really have Teachers and Students per se, I just used those names to simplify my explanation. Truth is, there are about 9 sub-tables that would inherit the super table, all of them in separate servers for separate applications, and no, I don't have <a href="http://www.wintercorp.com/VLDB/2005%5FTopTen%5FSurvey/TopTenWinners%5F2005.asp" rel="nofollow noreferrer">this</a> type of database, but we have pretty low end servers for the amount of transactions we have ;). You're right, my statements are a bit exagerated and I apologize for that, it was just to make you guys answer faster (sorry :P). The different servers are more of a business restriction than anything else (although the lead developer DID say that a common database to store the SuperTable would collapse under it's own weight -his words, not mine :S). Our clients don't like their information mixed with other clients information, so we must have their information on different servers -pretty stupid, but the decision-makers have spoken :(.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGeorge Stocker
    1. USThe WebMacheter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO(hard question) how can I store specific rows of a table in a different sql server?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO(hard question) how can I store specific rows of a table in a different sql server?
      1. This table or related slice is empty.
      1. VTDownMod
    1. COHow many students do you have?
      singulars
      1. PO(hard question) how can I store specific rows of a table in a different sql server?
      1. USRex M
    2. COEnough for the database to collapse, duh. :)
      singulars
      1. PO(hard question) how can I store specific rows of a table in a different sql server?
      1. USJack Leow
    3. CO@Jack so... like a trillion? :)
      singulars
      1. PO(hard question) how can I store specific rows of a table in a different sql server?
      1. USRex M
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload