Category: Windows / Internet

License: Trial

Limitations :

OS: Windows NT/2K/XP/2003

Size: 15.54 MB (16,294,302 bytes)

Introduction: Daily database management activities unavoidably incur changes to the database system upon which they are performed. These changes have an immediate and noticeable business impact which can be measured as: Costs related to time invested in the change operations themselves (i.e. upgrading a database version from the QA environment to the production environment) Costs related to malfunctions arising form change operations (i.e. loss of revenue due to downtime) Costs related to troubleshooting problems which arise from changes to the database system (i.e. restoring a malfunctioning system to an operational state). Change management is the collective set of disciplines and technologies that enable the IT professional to effectively perform changes to the database system thus reducing change related costs. When implementing a change management solution it is vital to take the business needs of your company into account. The company's profile will usually determine the type and scope of the organizational change management needs. At times the most important feature will be synchronization capabilities between multiple database servers while at other times it will be vital to support database snapshot-rollback operations. Many other usage scenarios exist for change operations, and a good change management solution will be flexible enough to support as many scenarios as possible. Furthermore, the change management solution must be robust enough to handle large databases both in terms of complexity and size. dbMaestro is a useful and reliable change management solution that has been designed from the ground up to support business scenarios for a wide range of organizations. Thus, dbMaestro can save considerable costs for companies that cope with database/software upgrades, software development, QA and support. Here are some key features of "DBMaestro Professional For MS SQL Server 2000": · Server configuration information · Compare database properties · Synchronize database properties · Compare database schema · Automatically find object dependencies (locate views using the table in focus etc.) · Filter objects by comparison result (new / different / deleted) · Synchronize database schema · Compare database data – one table ‘Quick compare’ · Compare database data - multi table content comparison · Compare database data - advance options (compare by Primary Key, Unique Index, Select columns to be compared and displayed, specify where clause etc.) · Filter comparison result by type (new / different / deleted) · Synchronize database data · Synchronize selected data (by context – new / updated / deleted, and specific row) · Text analysis filters – filter out blanks, new lines, letter case differences and comments In text based object (stored procedures, views, etc.) · Schema versioning and archiving engine Supports Private and Public versions · Data versioning and archiving engine Supports Private and Public versions · Power management tools – Query Analyzer and Enterprise Manager integration · Reports generation - dynamic schema and data changes reports · Reports repository – save your reports for others to see, and for future reference · Profile management – pre-define your schema and data tasks for faster operation and recurring tasks · Run scheduled tasks using a command line generator – save a version of you work in progress at timed intervals · Software upgrades for 1 year · Technical support for 1 year Requirements: · MS SQL Server 2000 Limitations: · 30 days trial