I have a simple project in mind. 2 apps with 2 seperate databases (sql server)
I want to have a third db that stores the information i want from db2 (lets call it Item Info) into a table Tb1 and when there is an insert on db1 (lets call it orders) store the info of order in Tb2.
Then insert order into db2 so i can have a log of the orders for each item .
Can you provide me with some tips where to start from or an e-book that covers my case or something relative?