DBArtisan Tips

Welcome to the DB PowerStudio Blog. This blog will cover all things about DB PowerStudio. DBArtisan is one part of the suite of tools known as DB PowerStudio.

The September edition of DBArtisan tips and techniques covered three tips for using DBArtisan.

  • DataSource Navigator
  • DBArtisan Utilities
  • Full DB Power Studio suite

You can view a recording of the event here: September Tips and Tricks 

The Datasource Navigator provides a hierarchy that descends from the datasource level to the level of individual database objects. It provides a visual method for navigating or drilling down through a datasource. From the Navigator, you can connect to and disconnect, from datasources as well as browse, filter, and initiate other actions against objects in all supported datasources on your network.

DBArtisan Utilities let you migrate schema and table data between databases on the same or different servers. Similarly, you can build and store a schema extraction script. Both features employ a wizard that walks you through the process and make use of similar options.  http://docwiki.embarcadero.com/DBArtisan/170/en/Using_the_Schema_Extraction_Wizard 

DB Power Studio is a powerful suite of tools to assist a DBA in managing databases across multiple platforms with a single Pane-of-Glass. DB PowerStudio combines four innovative solutions to help build and maintain mission-critical database applications, streamline the database change management process, and quickly pinpoint and fix performance bottlenecks.

DBArtisan

Perform Multi-platform Database Administration

  • Manage multiple platforms (Oracle, SQL Server, Db2, Sybase) from one UI
  • Proactively manage space, data and performance with built-in analytics
  • Easily find and fix performance issues using intelligent diagnostics
  • Move schema and table data across different platforms with ease
  • Protect data security with view, grant and revoke of permissions

DB Change Manager

Automate and Manage Complex Database Schema Changes

  • Quickly roll out and reconcile database changes
  • Reveal, track, and report on database changes
  • Comply with database audit and reporting requirements
  • Protect data privacy within the database environment
  • Track changes from multiple major database platforms

DB Optimizer

Automate SQL Tuning and Profiling

  • Streamline tuning of SQL code on major DBMSs from one interface
  • Tune SQL like a pro with automated performance optimization suggestions
  • Tackle complex SQL queries with visual SQL tuning diagrams
  • Pinpoint problem SQL with database profiling of wait-time analysis
  • Load test alternative SQL queries in simulated production environment

Rapid SQL

Develop SQL Code More Efficiently

  • Create high-performing SQL code on major DBMSs from one interface
  • Easily build complex SQL statements with visual query builder
  • Quickly construct, analyze and execute SQL code with code analyst
  • Simplify debugging SQL code, functions, and stored procedures
  • Collaborate effectively across development teams with version control

DB PowerStudio is available in two editions: The DB PowerStudio DBA edition includes all four of the products listed above. The DB PowerStudio Developer edition includes Rapid SQL, DB Optimizer and DB Change Manager.

Register for our next Tips and Techniques demo here: https://register.gotowebinar.com/rt/8391768911593950475

Anonymous