linking databases

Question

is it possible to link SQL databases in one program where one database is a master and the other is "smaller" so wen data or information is entered into the smaller database it is automatically updated in the master database using MVC