如何排除foxpro db中已删除的记录,而不将其迁移到SQL Server数据库? [英] How to EXCLUDE deleted records in foxpro db from being migrated to SQL server database?
问题描述
我正在使用SQL导入向导将某些Fox Pro数据库表导入到SQL SERVER 2008 R2中.导入完成后,表中的记录在fox pro表中被标记为已删除.如何忽略这些已删除的Fox Pro表的记录,以将其导入SQL Server.
我到处搜索解决方案,发现将SET DELETE设置为ON.但是我不知道该怎么办.您能帮我解决这个问题吗?
谢谢&问候,
Farhan
Hi,
I am using SQL Import wizard to import some fox pro data base tables into SQL SERVER 2008 R2. When the import is done the tables have records which were marked as deleted in the fox pro tables. How can I ignore these deleted records of fox pro tables to be imported into SQL server.
I have googled around for solutions and found to set SET DELETE as ON. But I dont know how it can be done. Could you please help me in solving this issue.
Thanks & Regards,
Farhan
推荐答案
要么PACK该数据库,要么在导入之前使用未删除的记录创建一个Temp数据
祝你好运
Either PACK that database or Create a Temp data with non-deleted records before import
Good Luck
试试这个
http://dbfviewereditor.com/dbu-clipper.html
DBF查看器
我建议先复制.DBF文件,然后将.DBF加载到DBFViwer中.
PACK .DBF. (PACK将从.DBF中删除所有已标记的已删除记录)
.DBF为PACK后,您将能够导入记录
祝你好运.
Try this
http://dbfviewereditor.com/dbu-clipper.html
DBF Viewer
I suggest to make a copy of .DBF files first then load the .DBF in the DBFViwer
PACK .DBF. (PACK will remove all flagged deleted records from .DBF)
Once .DBF is PACK then you will be able to import the records
Good Luck.
这篇关于如何排除foxpro db中已删除的记录,而不将其迁移到SQL Server数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!