We want to import existing data (now in a MS SQL Server database) into the streber MySQL database as new tasks, either by using a SQL script and then importing it with phpMyAdmin or by writing a VB script which feeds the data over the MySQL ODBC driver.
For this I need a deeper knowledge of streber's database structure: entities, relationships, etc. Therefore my questions:
- Is there a doc of the database structure available showing all the dependencies?
- Or could somebody recommend me a tool that does create such a document?
- Are there existing scripts (PHP, VB, Python, other) which do similar tasks and would need only little customization to be used for my job?
Thanks!