Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trigger between SQL2000 and FOXPRO database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-09 : 07:14:38
sandeep writes "Hi,

I am finding myself in difficult situation. I want to write a trigger between the FOXPRO snd SQL2000 database. the SQL DB is having same copies of FOXPRO tables. but condition is that, end user, wants his master data to be maintained in FOXPRO only.

I dont know how to synchronize the data between FOXPRO and SQL. triggers are to be written both way.

Please help.

Thanks in advance

Sandeep Vishwakarma"

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2003-01-09 : 07:25:23
Forget it. The only way to synchronize data is to use DTS, although I can't think of a reason why they want to keep the master data in foxpro.

It's like driving a big family in a Subaru Justy when you have a Chrysler SUV standing in the garage...

Go to Top of Page
   

- Advertisement -