I have a common product table in
db2. I want to make it one table because it has one inventory (stock of products). What is the best solution to share product table among two different database? I have few thoughts:
- Writing trigger on update/delete/insert one table and update another same time.
- Creating view on product table and used in second db (I don't know how)
- replication (I don't know how)
Can you guide me on the best way?