Diana OverviewDiana helps you find your way through all your database entities. Easily navigate through your tables, views, procedures and all over entities, across all your servers and databases. Find exactly what you are looking for - then script it, view the data in it, do a search for a substring in an entity source, search through all tables to find specific data in them, Browse through your code and quickly answer questions like 'which procedures deletes from this table, or updates this table column' etc... (we are adding features on a monthly basis) It Supports SQL Server (2005 - 2014) and MySQL. For now, its given completely free. (Which will not last for long)
- The absolutely most convenient, quickest way to browse through an endless amount of database entities and directly get to the one(s) you need - across an unlimited number of servers and databases
- Find entities by any part of name, substring within the code, or data in tables. Cross-database, Cross-server search
- Go deeper into the database engine: Find which entities are broken, which execute too slow, which do a Table Scan when and could benefit from an index... (SQL Server Only)
- Quickly browse your code by operations on entities: Which inserts to this table? which updates it, and what columns? Be able to quickly relate code to the underlying entities and the operations its doing on them
- Script entities using our own scripting engine, or delegate the scripting to the database itself (using SMO in SQL Server or the internal MySQL engine for MySQL databases)
- Use our context-free database scripting engine to generate a script that could be run on any database - blank or not. It will tell you the differences and change any database to be like the one you are scripting - both Schema and data. Generate report on the differences or actually execute them - itâ€™s all in one generated SQL script!
- Use our own SQL Compiler to find errors in your code. If you're using Randolph, The tools work together to get information about the history of its error (for example: if your code refers to a field that doesnâ€™t exist, who removed it and when?)
- What if your entities will be moved to another database? See how any group of entities would behave on any other database or server - without really moving them
- Build a full 'browser database' of your SQL code. Once our SQL Compiler compiles all your database entities, it builds a database of information about your code. Then you can easily query it, answers questions like: which entity has errors and what kind? Which procedures use this table in what way, call this function with what parameters? Etc... such queries work in cross-databases references and cross-server as well (if you are using linked servers)
- Diana contains our 'Randolph Zero' project: each time Diana scans your databases, it optionally detect changes in entities and saves them. This enable you to view the history of each database entity, as it changes. We now also added the compiler to this project: itâ€™s not only saving the entityâ€™s source, it also compiles it and builds a smarter history of it - for you to query at any time (for example: when was this field referenced, or this table inserted to, and when did it change and why?)
- Have you ever wondered what affect a certain DDL statement would have on your database? What would happen if a certain column is removed? What if its size changes? Its collation? Will it affect JOIN operations? Will data be trimmed anywhere? How will index usage be changed? Etc. Diana now enables you do see all that â€“ without actually executing the statement. Itâ€™s a comprehensive â€˜what-ifâ€™ for schema changes.
- Exposing some of the latest performance features of SQL Server 2014, like helping to point out missing indexes, slowest performing queries, etc...
- Open database tables with Marie-Alix directly from the main window - a quick way to do anything you need with your data
- If you are using Randolph, Diana has a quick and easy window into your history repository: Browsing changes occurring at certain times, seeing each entityâ€™s full history, etc.
- If you are using Colombo, You can paste any DML statement (INSERT, UPDATE, DELETE...) into Diana and it will tell you what this statement would do - what data changes would occur, what constraints might be violated and why, and will generate the complete undo script for it. Finally, SQL has an undo!