I have been using database (e.g. ABC) for my web application. Web application is accessed by customers as well as internal users. I need to have a different database (XYZ) on the same server having some of the tables of database ABC. Database XYZ will be accessed by customers. I want to sync these databases in such way that data inserted into ABC will also be added to XYZ immediately and vice versa. So that data added/ updated by internal users and customers will be available to each other right away. I can’t have triggers on both sides because SQL server does not allow to do so.
Please suggest a solution.
Thanks,