XBASE数据库WAV音频信息提取批处理

在开发新的管理信息系统时，原有数据库信息的一种处理方法是将所有信息提取导入到新系统中，这样可以避免对旧的数据库系统进行维护，也便于新系统的更新升级。一些基于dBASE X．FoxBASE．FoxPro等XBASE数据库的信息系统改造升级时，XBASE数据库DBF表文件向Oracle．SQL Sever等数据库加栽导入有各种不同的方法，但对于存储在FPT备注文件中的WAV音频信息数据的转换则没有好的解决办法。本文分析了各个版本XBASE数据库文件和WAV音频文件的结构，提出了基于文件的XBASE数据库WAV音频信息自动导出转换的处理方法，可以在脱离数据库系统操作环境进行信息处理，提高了数据库转换工作的效率，解决了无法转换XBASE备注文件中WAV音频数据的问题，具有很强的可操作性和实用性。

WAV Information Automatic Extract Method in XBASE Conversion

With the development of software technology and requirement of enterprise, some old information systems need to be updated or rebuilt with new technologies. Data transformation from old database to new one is very common in development of information systems. Some information in old systems is integrated into the new ones logically, and the data are stored in the old database physically, and the historical database must be maintained. Other methods convert the data into the new database, which can avoid the continuous maintenance of the old database and make the update and renew of the new system ease. Many methods can be used to realize the data transformation from XBASE(dBASE X, FoxBASE, FoxPro, etc.) to ORACLE or SQL Server. Most of these methods only transfer the table in DBF files, and information stored in FPT files is ignored. But sometimes the FPT information is very important. Based on the study of the characteristics and structure of the database files created by XBASE database and WAV file format, how to extract WAV information stored in FPT file as the general data type in XBASE is given. The records and WAV information in XBASE database can be automatically processed and converted with the method. The method can save a lot of time.