Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replicating data without using replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-10 : 07:29:13
Narayanan writes "We are trying to develop an independent automated datamart. The application has to pickup any changes in any objects similar to how replication works. But as a software we donot want to use replication to be part of it, instead we are trying to use triggers for it. Problem with the normal usage of trigger is that it has to be applied for all objects seperately. Instead what we want is to find out a central place where all transactions are recorded and to identify them from there. The question is how to implement the above idea. Any advice/suggestions?"

chadmat
The Chadinator

1974 Posts

Posted - 2003-03-10 : 23:48:27
I want to invent a circular transportation facilitation device, but I don't want to use a wheel.

Excuse my sarcasam, but why would you rewrite replication, rather than just using the built in replication engine?

-Chad

Go to Top of Page
   

- Advertisement -