Real-time sync of data from another database 1

[multiplex77]

Hi,

I have a web application that runs on SQL 2000. I would like to develop a way to synchronize the data on the Employees table of another database (MS Foxpro) with my SQL2K databse. Basically every change that is made on the Foxpro database should be updated on the SQL2K database (but not necessarily vice-versa).

I've done a bit of research about Linked Servers, but it seems that enables my application to read from the Foxpro DB directly, and isn't dealing with synchronization. Am I wrong?

Could anyone give me any information to point me in the right direction? Would really appreciate it. Thanks!

 

[ronnetp]

You can USE DTS Data Transformations Sevice
You can read from a FLAT FILE or ODBC and
schedule it to run every certain time.

 

[multiplex77]

Thanks ronnietp! That's helpful.

But what if I want a real-time sync, i.e, the moment the change is made to the Foxpro DB, the SQL DB is updated?

Thanks!

 

[ronnetp]

I dont remember very well I did this long time ago, but on Visual Foxpro 6.0 you can make a ODBC connection, First you
define a DSN for SQL server, then on visual foxpro you have
to make the connection, then you run and SQL update stamenent.
you can read on the Visaul FOX help something with this command SQLPrepare.

Hope this helps

 

[multiplex77]

Oh I see. Okay I'll give it a shot. Thanks a lot!