I have two SQL Server 2000 databases on one server, call them DB1 and DB2. I would like DB1 to send data to DB2 from particular fields, whenever new information is added to those fields. So if a user adds a new person in DB1, therefore adding new data in the Names and EmployeeNumber fields in DB1, these additions need to show up in the Names and EmployeeNumber fields in DB2.
What is the best way to do this? Would it be using DTS, or triggers, or something else? It would be great if this could be done in real-time, but perhaps that would cause problems for DTS.
Thanks much.
Henry
What is the best way to do this? Would it be using DTS, or triggers, or something else? It would be great if this could be done in real-time, but perhaps that would cause problems for DTS.
Thanks much.
Henry