sql server dts: SQL server with Foxpro -- sql server dts

SQL server with Foxpro

Vijay Mishra
10/27/2004 12:55:48 AM

sql server dts: Hi,

I have a foxpro database files created and used by the third party vendor application. Now I want to put some sort of replication between my SQL server and the foxpro. So that my application can use this data from the sql server. I need to update only sql server tables with the foxpro tables not vice versa.

One option which I was thinking is to write another program which will be scheduled to run periodically and it will read the data from the foxpro tables and copy that data on the sql server and marked the copied data in foxpro so that my program wont consider marked data next time to get that copied on sql server.

But I think this wont be the efficient way for doing this job although both the sql sever and foxpro datafile is one the different server but on the same network.

Any help or lead-ins to good articles appreciated.

Vijay

RE: SQL server with Foxpro

Allan Mitchell
10/27/2004 1:41:02 AM

You r solution could certainly be done in DTS. You will need to define
"Modeified" as this can relate to DELETED, ADDED, UPDATED rows.
You could add an identifier to each row that will help you do this.

If you are feeling adventurous you may want to take a look at this in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\replsql.chm::/replhet_7feb.htm

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.