如何将数据库从Filemaker迁移到Mysql? [英] How to migrate the database from Filemaker to Mysql?

问题描述

我正在重建基于Symfony1.4和MySQL 5.1的ERP系统.挑战在于以前的系统是基于Filemaker Pro构建的，我必须将所有以前的数据迁移到当前系统.为此，首先，我需要将所有数据移至完整保留先前架构结构的MySQL DB，然后可以根据需要编写脚本，将数据映射到当前系统架构.

I am rebuilding an ERP system based on Symfony1.4 and MySQL 5.1. The challenge is that previous system was built on Filemaker Pro and I have to migrate all previous data to current system. For that, first I need to move all the data to a MySQL DB having the previous schema structure intact and then I can map the data to the current system schema by writing a script as needed.

我应该如何进行第一步?是否有任何现有工具或流程可以做到这一点?

How should I proceed with that first step? Is there any existing tools or processes to do that?

任何帮助将不胜感激！预先感谢！

Any help will be appreciated! Thanks in advance!

推荐答案

最简单的方法是将FileMaker中的数据导出为某种通用格式.为此，您需要在FileMaker中打开文件，对于每个表，都需要转到与该表关联的布局，并使用菜单显示所有记录并导出.

The simplest way is to export data from FileMaker into some common format. To do this you need to open the file in FileMaker and for each table you need go to the layout associated with the table and use the menu to show all records and export.

确保仅导出数据字段(文本"，数字"，日期"，时间"和时间戳记")，因为FileMaker通常具有大量计算字段(计算"和摘要"). (为此，首先转到文件-定义数据库，然后转到某个表，按类型对文件进行排序，并记下最后一个数据字段.

Make sure to only export data fields (Text, Number, Date, Time, and Timestamp), because it's typical for FileMaker to have lots of calculated fields (Calculation and Summary). (To do this first go to File - Define Database, then to some table, sort files by type, and note the last data field.

这不会导出容器字段，但是大多数应用程序不会存储此类数据.仍然可以导出它们，但是需要自定义脚本.

This won't export container fields, but most apps don't store such data. It's still possible to export them too but it would require a custom script.

下一个选项是使用ODBC.之所以称为下一个"，是因为它不那么方便，而且通常较慢.

The next option is to use ODBC. It's 'next' because it's less convenient and usually slower.

如果没有FileMaker的副本，则可以从其网站下载30天的试用版；功能齐全.

If you don't have a copy of FileMaker, you can download a 30-day trial from their site; it's fully functional.

这篇关于如何将数据库从Filemaker迁移到Mysql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！