DB Change Manager is a Java-based application designed for managing and tracking changes to databases.
If you compare 2 datasources with lots of objects, you may need to adjust the memory used by DB Change Manager to avoid out-of-memory errors.
![How to adjust the Java heap size of DB Change Manager](https://blog.idera.com/wp-content/uploads/2024/01/How-to-adjust-the-Java-heap-size-of-DB-Change-Manager.png)
DB Change Manager is a Java-based application designed for managing and tracking changes to databases.
If you compare 2 datasources with lots of objects, you may need to adjust the memory used by DB Change Manager to avoid out-of-memory errors.
Creating backups and restoring them is crucial for maintaining the integrity and availability of data in Microsoft SQL Server. Here's a set of...
In this post, I’ll be sharing a macro based on this sample, updated to switch the bindings for all the domains included in the source dictionary and available in the target data dictionary (with the same name). If there’s no domain with the same name in the target data dictionary, the domain binding will remain unchanged.
For instance, if you intend to replace the domain bindings from the local data dictionary with those included in an Enterprise Data Dictionary.
In this post, I’ll share a video which shows how to export your Definitions and Notes from ER/Studio Data Architect, edit them with Excel, and finally import the updated Definitions and Notes back to ER/Studio Data Architect.
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Concurrency control is a fundamental part of any database...
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction The tempdb system database is a global resource in Microsoft SQL...
We are pleased to announce the general availability of DB PowerStudio version 18.5! IDERA’s DB PowerStudio provides a powerful cross-platform...
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction In the fast-paced world of database administration, staying ahead...
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft SQL Server is a powerful database management system, but...
As organizations grow, their data processing and storage needs often grow too. It can be easy to lose track of your inventory when you're in charge...
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Forecasting future SQL Server performance issues can often feel...
Introducing IDERA SQL SAFE Backup 9.2.1: The Latest Release of Our Leading SQL Server Backup Solution IDERA SQL Safe Backup is a comprehensive...
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft's SQL Server is a robust and widely adopted database...
Databases are vitally crucial to modern businesses across all market sectors. They are the repository of an organization’s information resources,...
There are different claims regarding the coinage of the term big data, but the concept of big data has existed since the mid-20th Century....
There are several examples where data theft has halted businesses or resulted in bad press that will leave a tarnished image. For instance, in 2017,...
ER/Studio Data Architect supports programmatic event handling.
To better understand when these events are triggered, I’ll share an updated script of the sample macro: ERSBasicHandlers.bas
Moreover, I’ll also share a second macro which speaks the definition of the selected entities|tables.
In a previous post, we have seen how to schedule a reverse engineering of a database using a macro and a quick launch file.
Likewise, I’ll share a macro which also uses the reverse engineer function, through the DiagramManager.ReverseEngineerObject.
However, instead of using a quick launch file, the macro directly extracts the connection settings from an Excel workbook.
Many different models and notations are supported by ER/Studio Data Architect. A model has one of these 2 model notations: Relational or Dimensional.
When we use a Dimensional diagram, there’s an additional tab available in the Table editor, Dimensional, where we can select the Dimensional Model Table Type and the Table Type and Data Architect updates how the diagram objects are displayed.
In this blog post, I’ll share a macro which replaces the Dimensional Model Table Type and the Table Type for all the Tables|Entities or a selected subset.
When we use ER/Studio Data Architect, we can create Submodels to document specific metadata.
For example, we can create Submodels to manage our Conceptual Data Model, to display the datatypes and Null option, or to show the Attachments and Data Security Information bound to the Entities | Tables.
In this blog post, I’ll share 2 different macros which can also export|import the entity and attribute attachment binding information to|from Excel.
If your organization deals with a high volume of customer data, telemetry, or other metrics, it’s likely you'll have some substantial databases to...
With ER/Studio Data Architect, we can use the Data Dictionaries to define Reference Values and to bind them to our Attributes|Columns.
I’ll share a script to generate the lookup tables for all the columns of the selected Tables which use Reference Values Lists. With Physical Data Model, it also generates in the Post SQL tab of the created Reference table, the Insert statements.
After a while, you may have added lots of projects in your ER/Studio Repository.
In this blog post, I’ll share a script which can generate a worksheet with all the Diagrams added to the Repository and remove diagrams from the Repository using a list provided through a spreadsheet.
On August the 22nd, I have presented a webinar: Do you need to model hierarchical data such as JSON, MongoDB, and Google BigQuery?
In this post, I’ll share a video with the most interesting extracts. This video provides chapters, so do not hesitate to navigate to the ones you are the most interested by.