Setup Triggers or simliar to insert record into a table in different database
Posted on 2011-09-16
I have 2 databases existing on 2 different servers.
One is SQL 2008 and other is SQL 2000
I would like to achieve following:
1. when a new record gets inserted into a table on 2008 DB, there would be a setup/code that automatically senses that and gets all data or part of that data and insterts it as new record into 2000 DB table.
Similar, when an exisiting record in 2008 is updated or deleted, the matching record in 2000 DB would also get updated or deleted too
What SQL feature/tool you recommend to me to use?
I heard about triggers and similar, but not sure how they work, where to set them up, what code to use, etc
If you can help me with an advise and maybe some sample code for some script or similar that has to be used, that would be great.
Thank you in advance.