January 8, 200818 yr Does the new SQL linkage capability in Filemaker 9 make it easier to periodically publish information to a SQL database? In our case, we have a Filemaker database of content. At present, CSV files are exported once a day from various tables and then batch imported into the SQL database that drives our website. It's inefficient and there are hundreds of thousands of records across dozens of tables, but it works reliably. Is there a good way to improve on this using the new capabilities? Note that we don't need to see what's in the SQL database, and don't need live updating of the SQL database, only periodic synching with the Filemaker one. Looking further ahead, is it madness to think of building a new content management system in Filemaker while retaining the web publishing from SQL?
Create an account or sign in to comment