473,703 Members | 3,300 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2906
(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
Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2754
by: Colin Colin | last post by:
We migrated our intranet site from IIS4 NT4 (\\GHCNT8) to a Windows 2003 server with IIS6 (\\NT58) using the IIS Migration Tools. I have a few ASP pages that access Foxpro data on a different server. I downloaded the Visual Foxpro ODBC Driver from MSDN. I exported (from the registry) the ODBC entries from the old server and imported them onto the newserver. I setup the Internet user guest account with rights where the Foxpro data is...
0
2914
by: me | last post by:
I've posted this in the microsoft news group but just noticed the comp newsgroups. What's the difference anyways? This one is a tricky one so I'm interested in seeing what all you gurus have to say. I'm trying to put a resume into a database. There are only three reports (see below). I suspect that the best structure for a resume database is as follows:
2
5540
by: Ivan | last post by:
Hi, SQL Server 2000 SP3 Windos 2000 Server SP4 I have a DTS package that imports data from a dBase IV databse with files located in two folders (dBF1 and dBF2). I use a transform data task to transform the data. They were running properly, but last week we installed W2K SP4, and
1
2236
by: Neel Word | last post by:
I need to develop an application (development platform: Win2000; target platform: Win98/ME/NT4/2000/XP), which would require file transfer functionality over dial-up and network. We could develop on .NET (1.1 or 1.0 - VS.NET 02/03) or using plain COM (visual c++). We'd prefer .NET though. Does anyone know of any products or COM API (or .NET classes) that can easily handle file transfer over dial-up
1
3185
by: mohd.osman | last post by:
I'm trying to access Visual Fox Pro Data from Sql Server 2000, Can anyone have any Idea ? Thanks
1
14358
by: Manish Bafna | last post by:
speaking of me, I'm not very new to Access, but I haven't worked on it as a professional. I know that you can fire queries in Access, but I don't think you can create views. i want to know that is there any way to create stored procedures or triggers in Access. Also, I want to know that can we migrate data from any platform? i downloaded this rdbms s/w from http://www.vaman.net/vmndataserver.asp i tried this s/w. this solved my most of...
2
2319
by: Andy Davis | last post by:
Has anybody tried and had any success exporting data directly from ACT! 2000 to an Access database? I need to transfer data from ACT! to Access, but the data is all imported as text, including date and number fields. If I transfer it to EXCEL first and then to Access, it is imported to Access in the correct format. Would like to know if there is an easier or quicker method of doing the transfer to Access? Regards and thanks in advance ...
1
1999
by: Biodigit | last post by:
The DTS works perfectly when I run it manually. However, when I run it as a job it fails. Before you ask if i'm running it under different security context. I have already made sure of that. I was logged into the server through remote viewer, when I created and ran the package, as well as scheduling the job. So the accounts they're running under are consistent. They're the same accounts as the SQL Agent is running under and it's the sys...
10
4777
by: Johny | last post by:
Is there a module for reading/modifing db files from Python? Thanks for help B.
0
8670
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9122
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9017
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7872
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6588
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5922
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3125
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2455
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.