将Microsoft Access数据库与Silverstripe网站数据库同步 [英] synchronise Microsoft Access database with Silverstripe website database

问题描述

我的客户有一个现有的网站，其中包含会员详细信息，会员投资组合和目录，这些网站大部分是在与Silverstripe CMS平台相关联的php中手动完成的，效果很好.他们的管理员还拥有一个脱机的成员数据系统-Microsoft Access，并且他们已经根据网站上的成员资格详细信息将成员详细信息两次添加到MS Access中.

My client has got an existing site with membership details, member portfolios and directories which are largely done manually in php associated with Silverstripe CMS platform which works well. Also their admin person has got an offline member data system - Microsoft Access, and they have been double adding membership details to MS Access according to the membership details on the website.

我的第一个想法是放弃MS Access并使所有数据库保持联机状态，但是即使在站点建立之前，他们已经从事MS Access多年了，因此我们正在考虑保留MS Access和站点数据库.

My first thought was to ditch the MS Access and keep all database online, but they have been working on MS Access for years even before the site was built, so we are thinking of keeping the MS Access as well as the site database.

这是我第一次体验MS Access，并且两种数据库结构的设置都不同.我只是想知道是否可以同步MS Access和网站数据库?例如，在线更新成员资格后，MS Access成员数据将自动更新.

This is the first time I am experiencing MS Access, and both database structures are set up differently. I am just wondering is it possible to synchronise MS Access and the website database? Eg the MS Access member data gets automatically updated when the membership is updated online.

我将如何实现?将使用哪种编程语言?同步脱机MS Access和在线网站是否存在安全性问题?任何步骤，链接或学习链接都会有很大帮助.谢谢.

How would I achieve it? Which programming languages would be used? Any secuirity issues to synchronise an offline MS Access and online website? Any steps, links or learning links would be great help. Thanks.

推荐答案

一种解决方案是使用CsvBulkLoader类，定期导出Access数据库并将其通过自定义CsvBulkLoader导入到SilverStripe中. http://doc.silverstripe.org/framework/en/howto/csv-import

A solution could be to use the CsvBulkLoader class, export regularly the Access db and importing it into SilverStripe via a custom CsvBulkLoader. http://doc.silverstripe.org/framework/en/howto/csv-import

或创建一个自定义BuildTask，以获取Access数据库并使用新数据更新SS.这可能会为您提供最大的灵活性，并且可以作为CRON作业运行，因此您不必手动进行. http://api.silverstripe.org/3.1/class-BuildTask.html

Or create a custom BuildTask that fetches the Access database and update SS with the new data. This would probably give you the most flexibility and this can be run as a CRON job so you don't have to do it manually. http://api.silverstripe.org/3.1/class-BuildTask.html

这篇关于将Microsoft Access数据库与Silverstripe网站数据库同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！