Re: SQL Triggers - Never Worked With Them

[Alan Campin <alan0307d@xxxxxxxxx>]

Why not just do the maintenance from the AS/400? Trigger fires and writes a
record to a data queue. Never ending server picks up record and uses Scott's
JDBC API to update SQL Server. We do exactly that with several projects. Let
me know if you have questions.

On Tue, Jun 14, 2011 at 10:39 AM, Mike Wills <mike@xxxxxxxxxxxx> wrote:

> We have a project now that requires us to sync data between the i and
> a MS SQL Server. I envision a table that collects the table, key(s),
> and what action was performed (insert, update, delete). This table
> will then be read by a C# program that will then process this table
> and copy the appropriate data to the MS SQL Server.
>
> I figured the best way to do this to avoid table changes or program
> changes is to use a trigger. I have never personally used or created
> triggers and now I am trying to figure out how to insert data into
> another table when a trigger is triggered. Is there any
> documents/articles/how-tos out there that you recommend to get me on
> the right path. Some of the things I have found so far doesn't really
> explain the process well enough that I can figure out how to create it
> myself.
>
> --
> Mike Wills
> http://mikewills.me
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.