I need to know what options I have for my next problem:

I have 2 databases (sql server 2012)

  • first for an ERP
  • second for an website

For the website's database, I want to use a table (customer) which is created in ERP database.

I need a copy in real time of that table, in website's database. When a customer is entered by erp, it should appear in website too. Vice-versa is not necessary

How can I do this?

  • 2
    What happens when data is changed in the website "and" the ERP? Which one should prevail? – Nestor Apr 30 '17 at 20:37
  • Why is vice versa not necessary - because customers are not entered via the website, or because some other existing mechanism adds customers entered vias the website into the ERP? – RDFozz May 1 '17 at 0:44
  • Yes, because customers are not entered by website, just by ERP. I need a mirror of that ERP.customer table. – Ionut P. May 1 '17 at 5:46

What you're looking for is Transactional Replication.

It allows you to replicate specific objects from one database to another.

|improve this answer|||||
  • It can affect the speed of ERP database ?? – Ionut P. Apr 30 '17 at 19:36
  • @IonutP. I can't answer that. I know nothing about your hardware, transaction throughput, etc. I'd generally say no, but you'd have to test it out. – Erik Darling Apr 30 '17 at 19:40
  • For just one table on the same server you shouldn't have any performance issues. – Matt McDonald Apr 30 '17 at 20:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.