What’s Inside DB PowerStudio 19.0: Smarter Profiling and UI Enhancements The DB PowerStudio 19.0 release sharpens the toolset across DBArtisan, Rapid SQL, DB Optimizer, and...
The DB PowerStudio 19.0 release sharpens the toolset across DBArtisan, Rapid SQL, DB Optimizer, and DB Change Manager, introducing powerful enhancements for Oracle and PostgreSQL users, along with UI upgrades, usability fixes, and quality-of-life improvements.
Whether you’re managing complex schema extractions, tuning slow queries, or maintaining role-based access, DB PowerStudio 19.0 helps you get there faster with fewer clicks, clearer results, and greater control.
Let’s dive into what’s new.
Enhanced Oracle Tablespace Compression
Oracle users now benefit from automatic compression during schema export/import operations. The default setting for tablespace extraction is now COMPRESS BASIC, improving performance and reducing storage consumption across the board.
This change makes large-scale data movement easier, particularly in high-volume environments where time and space both matter.
PostgreSQL Function Reporting Now Supported
Function-level visibility has arrived for PostgreSQL. You can now generate reports that include stored functions, making it easier to document and audit your codebase. This is especially valuable in environments with heavy use of custom logic and layered transformations.
Complete DDL Extraction, Including Clustered PKs
The DDL Extract tab now provides a full and accurate schema snapshot, including clustered primary key constraints. That means no more gaps when reverse-engineering structures or generating archive jobs. Your schema exports now reflect everything you’ve defined.
Modernized ‘New Data Source’ Wizard (Windows 11 Support)
A more intuitive and polished UI experience awaits Windows 11 users. The updated ‘New Data Source’ wizard includes corrected dropdown behavior, refreshed styling, and consistent visual cues that match the OS experience. Clean and straightforward, just like it should be.
Seamless PostgreSQL Query Profiling
DB Optimizer 19.0 speeds up your workflow by letting you launch the Explain Plan directly from the SQL tab in the profiling editor. That means less toggling between tabs and faster round-trips from query to performance insights, perfect for diagnosing bottlenecks on the fly.
Smarter Role Management for Oracle
Modifying user roles just became smoother. The Users and Roles tab now supports in-place edits, reducing friction and improving accuracy during permission updates. It’s a small improvement that will save you time with every security adjustment.
Better Oracle Data Comparison Reports
When comparing live vs. archived Oracle data sources, empty or null properties are now clearly shown, eliminating the confusion of ambiguous “Not Found” entries. This makes schema comparisons more accurate and far easier to interpret.
MAXDOP Values Now Auto-Formatted for SQL Server Indexes
Index creation just got more readable. Large MAXDOP values (e.g., 1000 or 5000) are now automatically formatted with commas to reduce syntax errors and improve scanability. This formatting tweak helps developers follow SQL Server conventions while keeping scripts easier to maintain.
Version 19.0 resolves these usability issues:
This isn’t just a round of minor polish. DB PowerStudio 19.0 addresses real-world pain points across all four tools:
From database developers to DBAs and performance engineers, every role benefits from the cleaner, faster, more accurate experience in 19.0.
Explore Each Product Further:
DBArtisan – Schema Management Made Easy
Rapid SQL – Advanced Query Design and Editing
DB Optimizer – Accelerated Tuning and Profiling
DB Change Manager – Reliable, Auditable Change Control
Contact our sales team to get a personalized demo of our database management software for SQL Server!
