FAQ: How Do I Build SQL Backend
From Requirements Management Database Support MediaWiki
FAQ:
How do I go about setting up an SQL backend?
Answer:
The Open Data Structure of the Requirements Management Database allows you to build your own backend based on the data tables and fields in the Project File (including an SQL back-end). If you can leverage a more sophisticated database already installed at your site then you might also get some additional benefits - such as managed backups of the data.
To view the tables and fields that exist in the Project Files, open the project file directly from within Microsoft Access and hold down the SHIFT key when clicking through the security warnings – that will bypass the dialog box and get you straight into the data structure.
This is a script that can help you automatically converts Microsoft Access databases to MySQL databases: http://www.kofler.cc/mysql/msacc2mysql.txt
- Previous FAQ: FAQ: How Do I Access Requirements Across WAN
- Next FAQ: FAQ: How Do I Create My Own Custom Forms Reports
- Back to other FAQs: FAQs Support Home of the Frequently Asked Questions
