Shusheng SQL Tool
What is it ?
Who need it ?
- Web based MS SQL Server 2000 (MSDE) client tool for database Admin, Developer and End User.
- Design, Create, Query , Edit, Backup, Manage and Monitor your Database anytime, anywhere.
- Optimize SQL query. Find out where is the bottleneck of your SQL script or SQL object like stored procedure, view and user defined function. Screenshot
- Blob data editor. View image, play / download / upload audio (almost all format, include mp3), video, RealMovie, Flash Movie from SQL database. Store any binary file in SQL database. Screenshot-1, Screenshot-2, Screenshot-3
- Pure ASP script, no installation needed. Freeware for Educational usage.
Why must have it ?
- DBA ( Database Admin )
- Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
- Monitor connections, locks and performance of SQL server. Kill bad process.
- Administrate security for server logins (Windows and SQL accounts), database users and roles.
- Assign permission to user(s), role(s), object(s). Support column level permission.
- Backup, Restore and Repair database. Compress Transaction Log.
- Developer ( Database application )
- Color-coded Editor for View, Stored Procedure, User function, Inline function and Trigger.
- Create and modify database, table, index, constraint (default, check and foreign key).
- Automatic Duplication and Orphanage check.
- Database-wise search for a specific value (number, datetime or text format).
- Database-wise search for a specific object (table, view, stored procedure, user / inline function and trigger).
- Automatic database documentation / dictionary.
- Automatic Parent / Child Key tracking and Object Dependency tracking.
- End User ( Specific permission might required from DBA )
- Query any data with a color-coded SQL panel.
- Edit table data in a spreadsheet-like Editor.
- WYSIWG Editor to edit and store large plain/HTML document in the database.
- Create user table, view, function, trigger, index and constraint.
- Execute any SQL script (multiple, compound query), MS DOS command.
- Save and open SQL script from local disk.
- Play MP3, Mpeg, RealMovie and Flash Movie stored in sql database from Internet.
No other tool but this one can provide these: