Go Up to Prerequisites and Preliminary Tasks
DBArtisan is an industry-leading database administration solution for managing Oracle, Microsoft SQL Server, Sybase, PostgreSQL, IBM DB2, and MySQL databases. Its cross-platform capability allows users to efficiently manage heterogeneous database platforms easily using a single front-end tool. Using DBArtisan, users boost their productivity by using a single tool for all their databases, regardless of the vendor.
Your new application provides tools that can be used by a number of functions within an organization using DBMS from multiple vendors, in testing, development, or production environments.
Datasource and Server Management: Datasources must be registered. Datasources can be registered manually or semi-automatically. Storage can be registry-based or file-based, and a network storage option facilitates shared use of datasource catalogs.
Object management tools: Your application supports a wide range of database objects and related elements for each DBMS. You can create new objects, edit existing objects, and use a range of object operations that support common, general or DBMS-specific actions.
Coding Environments/Editors: Fully-featured environments dedicated to SQL, DDL and Active Script development are provided. Execution options are available as appropriate, and environment-specific related features, such as rollback/commit and query plan options, are provided. Related coding aids include on-the-fly semantic and syntactic validation, text substitution shortcuts, and visual query building tools. Related execution tools include script and file execution facilities.
Schema and data utilities (DBArtisan only): Schema extraction, migration, and publication wizards let you quickly extract and move schema and data across environments and even across DBMS types. DBMS-specific import/export, load/unload, and backup/restore utilities are also available. A Data Editor lets you edit your tables in real-time, supports all editable datatypes, and provides Unicode options. Table data can also be imported from formats such as spreadsheets.
Project Management, Version Control, and Script Library: Database project management facilities help you organize, alter, and keep track of changes to database objects or SQL scripts. The project management facilities act as a repository to maintain all source code for a database project. DBArtisan also incorporates version control functions and build management facilities to help you manage and build projects.
Other Time-savers and Productivity Tools: Working within the DBArtisan environment, you have access to database and file search facilities, use the visual difference to compare files or database objects, and access the Microsoft Windows task scheduler.
License-specific Add-ons: Depending on the licenses you purchased, you have access to the following tools:
- The DBArtisan Analyst Series includes advanced space, capacity, performance and backup management capabilities. They let you predict and prevent storage-related problems, trend data and object growth over time, and pinpoint performance bottlenecks.
- Debuggers, available for IBM DB2 for Linux, Unix, and Windows, Oracle, Sybase, and SQL Server, let you test functions and procedures. A Profiler is available for Oracle datasources.