I have two seperate databases with different table names and column names.
One database runs a client's internal office functions. The other database
contains the clients e-store. When an order is entered/modified/ deleted it
needs to copy this change to the internal server and vice versa. I can't use
replication services because the tables and columns between databases are
different. Is dumping new/edited/deleted records in a temp table and running
a scheduled dts package the best way to accomplish this task. Or can I use
triggers to run between the two databases and accomplish this?

I would like to use triggers if possible to keep sync as real time as
possible. If triggers are possible can the reponder to this tell me how to
use triggers to affect two seperate databases or post some sample code.

Thanx in advance.
--
I just need the bear necessities

You could use replication + DTS (Ask on the replication NG - Hilary Cotter
or Paul Ibison)

DTS will also do it for you but it is not a real-time solution.

Triggers? Problem there is on a heavy transacted system they will cost in
performance.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Mad Matt" <MadMatt (AT) discussions (DOT) microsoft.com> wrote

Thanx,

Two questions still though.

First question, I am fairly new to the forums (Ask on the replication NG -
Hilary Cotter or Paul Ibison). I'm assuming this means to ask in the sql
server replication group but how do I the above people directly.

Second, would using triggers to activate DTS be as intensive as just
triggers alone. If not how do I activate a DTS package with a trigger. I know
you can do it with xp_cmdshell but haven't been come up with the correct way
to implement this in a trigger.

Thanx again in Advance,

"Allan Mitchell" wrote:

1. Chances are that if you post in the Replication NG paul or Hilary will
pick it up anyway.
2. You can implement DTS through a trigger but this means calling an
external COM process for what? Every row inserted? Intensive !

How can I execute a DTS package from a trigger
(http://www.sqldts.com/default.aspx?219)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Mad Matt" <MadMatt (AT) discussions (DOT) microsoft.com> wrote

Thanx Allan,

Will post in the Replication NG

"Allan Mitchell" wrote:

Thanx Alan,

Will post to the Replication NG.

"Allan Mitchell" wrote: