Managing large data estates is challenging. It’s hard to track the dependencies among your databases, particularly if your data estate is constantly changing through growth or acquisitions.
Common problems include difficulties understanding the differences among databases, inadequate solutions for comparing data schema, and the inability to track dependencies and connections so that you can successfully manage data, users, and security.
DBA xPress helps data managers visualize data dependencies across their data estate
SentryOne DBA xPress simplifies managing large data estates by providing solutions for comparing data schema and browsing through database content:
Compare databases and synchronize schema and data within them
Analyze dependencies and connections among tables, users, functions, and security policies
Browse content of SQL Server databases, access the scripts for each object, and export them into an XML file
Automating repetitive tasks can save you time, reduce the risk of human error, and streamline processes. Enjoy these benefits as you manage your ever-changing data estate—with DBA xPress and the command line, you can automate schema and data comparisons.
Run data and schema comparisons as part of your CI/CD pipeline
Run data comparisons against your production and development environments on a set schedule to keep data synchronized between databases
Run regular schema comparisons and automatically synchronize schema differences as well as generate scripts that will write the results to a file for historical tracking purposes
When automating DBA xPress comparisons through the command line, you can specify actions that will be executed based on the results of the comparison. For example, generate a SQL script that outputs the results of the comparison and/or immediately synchronize databases.
The DBA xPress Schema Inspector helps you view the differences between database schema and synchronize databases. You can compare a production database to schema in a development environment. You can see various statistics about the items you're comparing, apply filters, change settings, and create reports. You can also synchronize the two environments in three different ways:
You can apply the synchronization directly against the target database, create a script that can be used to update the target, or use a hybrid approach that applies a direct synchronization and generates a script that you can re-use.
The DBA xPress Data Inspector creates detailed comparisons between the data stored in two different databases and helps you sync data between databases. When the comparison is complete, you can see details such as tables that have rows found only in the source or only in the destination, as well as rows that are different between the two.
As with the Schema Inspector, you have three options for synchronizing databases: through direct synchronization to the target, by generating a script, or through a hybrid method that creates scripts and directly alters the database.
Data Surf displays data in a table and shows how that data relates to other tables. With Data Surf, you can generate a diagram of your data tables and the rows in that table, including a display of parent tables and child tables. You can change focus by adding or deleting tables to the diagram. You can zoom in and out on the diagram, change the color of the tables, and color the node and all dependents. You can also save your session and export the diagram as an image.
Schema Surf allows DBAs to find out how objects in a database are related, including schema dependencies between security policy, functions, tables and users. You can easily see schema dependencies, foreign key dependencies. You can color-code nodes and dependents. You can zoom in and out of the diagram you create, and navigate through the diagram. You can save the session and export the diagram as an image.
Data Space Analyzer helps you manage your growing data estate by displaying graphs of available database disk space. After selecting a database to analyze, you'll see a graph of the primary file group. You can drill into the details, including information about specific tables and indexes, and you can change the style of the chart.
The object browser in DBA xPress lets you view detailed information about objects inside a SQL Server database and generate DDL scripts. With the object browser, you can browse, search, and filter the contents of SQL Server databases and instantly access the script of each object. You can drill into and filter on all objects in a particular schema, including tables, primary key constraints, and check constraints.
DBA xPress is licensed per user, per machine where it is used. Please contact sales@sentryone.com for more information.
DBA xPress is a suite of tools designed to aid the DBA with the management of their SQL Servers and data. BI xPress Pro includes DBA xPress with it.