Are we able to build a interface link between 2 SQL database in order to have data replicated?

Question

Dear all Experts,

We are looking for a way to have sales data to flow from 1 database to another database on same SQL server. Can we build or have a link between 2 database? If yes, how to and how much effort will that be?

Thank you.

DatabaseDummy

Answer 1

There are two ways off the top of my head.

1. Trigger on the Sales Data table or tables on insert/update/delete that does the same to the other database.

2. Replication - fairly overkill but more transparent as you will notice failures in data transfer. Although replication is most complex of the two.

This is not the exact solution but I am sure you can do a bit if reading, Concentrate on 1 and 2 if you are interested.

---

Kind Regards Nick Kemp.

Answer 2

Hi Nick,

Thanks for the reply. Would a SQL developer knows how to do a link replication? Export data from DB1 and Insert into DB2??