SQL Triggers: Transfer Data from SQL Server 2000 to Visual FoxPro DBase

[bwalke]

Hi all,

I am fairly new to using triggers and was seeking some help from those
that have experience with them. I am looking to transfer data from a
SQL 2000 database to a Visual FoxPro database on another computer. I
would like to transfer about three fields of data to a VFP table each
time an insert is made on the SQL table. I am some what familiar with
the structure of creating the trigger but here is what I would like
help with: Selecting the SQL data to transfer, Connecting to VFP
database, Insert SQL data into VFP table.

CREATE TRIGGER [xyz] ON [dbo].[AAA]
FOR INSERT
??? Select a,b,c from SQL table

??? Connect to VFP Database and Table

??? Insert into VFP table Values a,b,c
Any information, tips, or even an example Trigger procedure would help
and be greatly appreciated.

Thank you,

Brett

[Erland Sommarskog]

(bw****@lbrspec .com) writes:

I am fairly new to using triggers and was seeking some help from those
that have experience with them. I am looking to transfer data from a
SQL 2000 database to a Visual FoxPro database on another computer. I
would like to transfer about three fields of data to a VFP table each
time an insert is made on the SQL table. I am some what familiar with
the structure of creating the trigger but here is what I would like
help with: Selecting the SQL data to transfer, Connecting to VFP
database, Insert SQL data into VFP table.

The trigger as such would be simple:

INSERT VFP.db.catalog. tbl (...)
SELECT col1, col2, col3 FROM inserted

You would have to set up VFP as a linked server with sp_addlinkedser ver.
The really tricky part would to be to find out how to write that four-
part notation exactly. Since I have now knowledge of FoxPro, I cannot
really assist on that part.


--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp