在.dbf文件和Sql Server 2005之间同步数据 [英] Synchronize data between .dbf files and Sql Server 2005

问题描述

我有一个用delphi编写的遗留应用程序。数据库存储在多个.dbf文件中。我必须使用SQL server 2005在asp.net中公开一些页面。现在我想同步这两个数据库。

I have a legacy appplication written in delphi. Database is stored in multiple .dbf files . I have to expose some pages in asp.net using SQL server 2005. Now i want to sync both of these databases.

我应该如何进行。 p>

How should i proceed.Please suggest.

推荐答案

两个应用程序应该有足够精确的日期字段（SQL中的时间戳，我不记得在DBF中具体）。每次更新字段时，您还需要更新此字段。

Both applications should to have precise enough date field (timestamp in SQL, I don't recall specific in DBF). Everytime you update a field, you also update this field.

这样，要同步两个数据库，您只需要比较记录ID +日期字段，更新。

This way, to sync both databases you just need to compare record ID + date field to find records which needs to be updated.

这篇关于在.dbf文件和Sql Server 2005之间同步数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！