|
web-based SQL programming tool for sql programmer. Program stored procedure, view, user function, inline function, trigger, checks, job steps and other sql scripts from a web browser with syntax highlighting, syntax check and sql query optimizer.
1. MDI SQL Programming Interface, exec / stop sql query.
2. Login as Windows or SQL user.
3. Streamlined for large sql query program (return million rows without freeze).
4. Pure ASP script program, no installation needed.
For DBA
o Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
o Monitor sql connections, locks and performance of SQL server. Kill bad sql process.
o Administrate security for sql server logins (Windows and SQL accounts), database users and roles.
o Assign sql permission to user, role, object. Support column level permission.
o Backup, Restore and Repair sql database. Compress sql Transaction Log.
o Virtual MS DOS prompt window on sql server side.
For SQL Programmer
o Color-coded SQL Program Editor for View, Stored Procedure, User function, Inline function and Trigger.
o Create and modify sql database, table, index, constraint (default, check and foreign key).
o Automatic sql script programming for Duplication and Orphanage check.
o Database-wise search for a specific value (number, datetime or text format).
o Database-wise search for a specific sql object (table, view, stored procedure, user / inline function and trigger).
o Automatic sql database documentation / dictionary.
For SQL End User
o Query any data with a color-coded SQL panel.
o Edit sql table data in a spreadsheet-like Editor. (with row/column copy/paste/reset, fill down feature)
o WYSIWYG Editor to edit and store large plain/HTML document in sql database.
o Create user table, view, function, trigger, index and other sql constraint.
o Execute any SQL script (multiple, compound query), MS DOS command.
o Save and open SQL script from local disk.
|
