2

I am trying to implement source control for my MS Access project (using git). The question, How do you use version control with Access development?, helped me setup exporting/re-loading from text for queries, modules, forms, macros and reports. For the table schema, I attempted to export create statements using the code from this other question, Table Creation DDL from Microsoft Access. I was then able to load tables back into Access using these create statements. Unfortunately, foreign key definitions are not exported. Is there a way to export the foreign key references as DDL statements?

Community
  • 1
  • 1
Christine
  • 512
  • 2
  • 9
  • 21
  • There are some notes here: http://stackoverflow.com/questions/698839/how-to-extract-the-schema-of-an-access-mdb-database/699516#699516 – Fionnuala Oct 21 '11 at 23:07
  • Crossposting [this solution](http://stackoverflow.com/questions/698839/how-to-extract-the-schema-of-an-access-mdb-database/9910716#9910716) – Eric G Mar 28 '12 at 15:27

1 Answers1

0

I use OASIS for this purpose. Although this is originally designed to work with Subversion (TortoiseSVN), ignoring the SVN part makes this tool very helpful for Mercurial as well, so why not Git, too? It's not free, but it's worth the (small) price.

In short words, OASIS exports and imports every Access object to and from files (one file per object), avoiding the partially crazy implementation of MSSCCI ("tables and other objects"). Having those files, you may use any version control system you want.

Christoph Jüngling
  • 1,080
  • 7
  • 26