Context Database Designer does what very few specialists and costly tools may - it can automatically create/alter/drop DDL scripts for just about any search engine. What's more, it also can import SQL DDL scripts from just about any database, which can be accomplished by a highly customizable SQL generator/parser - an exceptional element created by Contexts Software. The only thing needed to support a different database is developing a straightforward text profile that defines this particularSQL scriptsparticularsal sort of database.
When creating an RDBMS with Context Database Designer you.
- Layout and join tables directly in the diagram canvas.
- Produce a variant checkpoint that automatically generates SQL DDL script to your target search engine.
- Use the script to create a new database.
- Proceed to design and alter your schema, every time creating a brand new version checkpoint with an upgrade script.
- Employ updates to your own development, phase and production databases.
Typically, you will probably never have to write or operate DDL scripts when using the aforementioned arrangement. Your database design procedure's entire background will be superbly recorded in diagrams and variant checkpoints (that you will always have the ability to revert and compare to if required ).
Context Database Designer Great Features:
- Professional appearing diagram perspective with Various Methods of displaying relationships and fields
- Virtually infinite Undo/Redo pile
- Smart connectors tackling
- Multi-selection
- Copy/paste, such as gluing as enhanced metafile into any text editor, such as Word, such as documenting
- Simple HTML markup in text tags
- You can create multiple diagrams to the Exact Same schema
- Automatically laying out big diagrams to smaller pages for printing (with account for gutter) with the capability to choose which pages to publish
- Drag & drop tables and connections from the schema tree view
- Draw tables and connections right on a diagram
- Stored diagrams and schema within a single document
- Import/Export diagram and schema from/to XML
