Options for having same tables in 2 different data bases 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?
What you're looking for is Transactional Replication.

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