locked
getting a table from another database into sql server RRS feed

  • Question

  • Hi everyone:

    There is a table in a visual fox pro database that I need to use in an application I am building.  I am using sql server 2000 as my database to house my data.  I was wondering if there was a way to pull the data from foxpro into sql server and have it update the sql server database whenever changes are made to the foxpro database?
    Thursday, August 17, 2006 6:06 PM

Answers

  • I believe you could use a merge join on the fox pro table and the destination table. Set to full outer join with a conditional split to send rows with null (unmatched) rows to the destination and the others (matched) to the trashbin. Basically a poor man's CDC.

    Kirk Haselden
    Author "SQL Server Integration Services"

    Saturday, August 19, 2006 11:30 AM