At work, the database is not document at all. In addition, the stored procedures, functions and views are all encrypted, it assigns many tools for you to document these objects to me. I have all the plain SQL files that generate database, schemas, tables, tasks and all We do.
I want to know, is there any device that can read these files and like a dosage-document? Preferably open-source or freeware.
I have very close to the project slides of EasySoSoft's Hyper SQL and SourceForge, though both are very PL / SQL specific. I have something that reads the source source files (which understands the different things of T-SQL), parses them, and I get:
- The SP, UDF, Etc. The list of objects is defined in each file
- The list of objects (both tables / views and procs / functions) depends on each object (directly and, if possible, indirectly)
- Calling and Dependency Graphs (ie what to say And what is called what can be done)
- If SP uses a table / view, how is it used (INSERT / DELETE / UPDATE / SELECT / mix ???)
I have already developed a small pearl script that is trying to get these files at least the first digit - but then this is just a hack and lots more Lack of polish I'm sure there should be a device that works, believe me I do not have to code myself.
We use red gate SQL doc to generate Use them.
However, it does not work from a database: it is easy to read everything from system tables (permissions, dependencies, datatype etc.) compared to parse scripts. What does the Parsing script DB engine do ...
Can not generate empty dB from source files (aside from encoding) and generate from it? Or if you have the right, decrypt?
Comments
Post a Comment