Database Manager provides database management via a task oriented tool for SQL Server and MSDE. Features and capabilities include:
- Connect to your SQL Server and MSDE database locally or over the Internet
- Perform SQL Server and MSDE database backup and restore remotely
- Create, alter, and script all SQL Server and MSDE database objects including stored procedures, triggers, and views
- Create and schedule SQL Server and MSDE database jobs including automated backup
- Create, attach, detach, and shrink SQL Server and MSDE databases
- Object search/filtering based on code content (for example a search for all stored procedures containing '-- modified on...' as part of their content) or object name
- Index rebuilding and database fine-tuning
- 1-click enable/disable triggers, foreign keys, and check constraints
- 1-click stored procedure and trigger compilation
- Manage Security and user connections
- Query window for running SQL queries and editing data