470,602 Members | 1,472 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,602 developers. It's quick & easy.

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

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

Jul 23 '05 #1
1 2707
(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_addlinkedserver.
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****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Neel Word | last post: by
2 posts views Thread by Andy Davis | last post: by
10 posts views Thread by Johny | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.