Post reply

Synchronizing SQL & FOXPRO

  • December 27, 2005 at 11:45 am

    #166948

    Hi All,

    We have our current database in FOXPRO and now we are currently trying to move in to SQL and we are planning to implement in one department currently. Is there any way to synchronize FP and SQL tables like if the FP tables got updated it should update the SQL table automatically and vice versa so that we can compare both the tables and make sure the application is running without any problem until we move fully in to SQL since the rest of the applications depends on the FP database.

    Thanks

    Senthil

  • December 28, 2005 at 6:59 am

    #611679

    Hi Senthil,

    What version of FoxPro are you using. If you are using Visual FoxPro 3 or later, you can create a trigger in the VFP database that will execute code to update your SQL Server database every time an insert is made.

    The other option is to batch update your SQL Server tables. This would need to have a datetime stamp for last updated. Then on an hourly or daily basis, you can query for any changes to the FoxPro database in the past hour/day/week/whatever and perform your updates, inserts and deletes.

  • December 28, 2005 at 9:41 am

    #611717

    Also, pls don't cross post. We check all the forums.

    There are other answers in the other thread.

  • January 19, 2006 at 9:24 am

    #615842

    hi there

    Im checking other posts trying to find an answer for this...

    anyone has the direct link to the thread regarding this solution??

     

    thanks

    sergio

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply