DBA xPress
Free tools to manage your SQL Server data estate. Compare and analyze databases.
Automate schema and data comparisons through the command line
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 and do the following:
- 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, automatically synchronize schema differences, and generate scripts designed to write the results to a file for historical tracking purposes
- When automating DBA xPress comparisons through the command line, you can specify actions to be executed based on the results of the comparison. For example, generate a SQL script designed to output the results of the comparison and/or immediately synchronize databases
Schema Inspector
The DBA xPress Schema Inspector can help you view the differences between database schema and synchronize databases. You can compare a production database to schema in a development environment. Additionally, you can see various statistics about the items you're comparing, apply filters, change settings, and create reports. You can also synchronize production and development database environments in three different ways:
- Apply the synchronization directly to the target database
- Create a script you can use to update the target
- Use a hybrid approach applying a direct synchronization and generating a script you can reuse
Data Inspector
The DBA xPress Data Inspector tool can create 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 with rows found only in the source or only in the destination and rows that are different between the two.
As with the Schema Inspector SQL developer tool, you have three options for synchronizing databases:
- Through direct synchronization with the target
- By generating a script
- Through a hybrid method designed to create scripts and directly alter the database
Data Surf
Also included in DBA xPress, Data Surf displays data in a table and shows how this data relates to other tables. With Data Surf, you can do the following:
- Generate a diagram of your data tables and the rows in the table, including a display of parent tables and child tables
- Change focus by adding tables to or deleting tables from the diagram
- Zoom in and out on the diagram
- Change the color of the tables node and all dependents
- Save your session and export the diagram as an image
Schema Surf
Schema Surf allows DBAs to find out how objects in a database are related, including schema dependencies between security policies, functions, tables, and users. With this tool, you can also do the following:
- More easily see schema dependencies and foreign key dependencies
- Color-code nodes and dependents
- Zoom in and out of the diagram you create and navigate through the diagram
- Save the session and export the diagram as an image
Data Space Analyzer
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 change the style of the chart.
Object Browser
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 do the following:
- Browse, search, and filter the contents of SQL Server databases and instantly access the script of each object
- Drill into and filter on all objects in a particular schema, including tables, primary key constraints, and check constraints
