June 10, 2009 at 4:14 pm
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,
June 10, 2009 at 8:13 pm
Whats the problem? why not just set up transactional replication?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply