RDM Demerit: Data locked in database
Scenario
You have compiled a respectable and complex dataset. Now you need a way to run complex and repeatable queries against your data. A relational database and SQL seem like the obvious solution to all your problems. You are not the first to be at this point. The path of digital research is paved with undocumented and unpublished Filemaker (and other) databases.
Solution
Relational databases are a wonderful and powerful tool. Please first consider whether your data requires the power of a full-blown database system, maybe CSV files and an R script would work just as well? If you really need the power of SQL and a relational database, design and document your database in a way that you can export and archive your data as system independent as possible. If you are unsure what to do, contact the DCH or your local RDM support team.