No Results Found

Oops, we could not find that web page!

Try browsing other articles or go back to the home page.

Featured Blog

ER/Studio Data Architect 20.1 General Availability

We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.1 ER/Studio 20.1 delivers a variety of improvements and bug fixes to SQL generation to support your design projects. This makes ER/Studio more reliable, faster, and with better-documented output. Get the latest version today! ER/Studio Data Architect 20.1 Updates to Data […]
Read More

Macros – Add even more custom properties

This post follows the previous one, “Macros – Add custom properties to specific objects”, where we shared scripts to automatically bind Attachments to ER Objects.

In this one, we will share new versions of the different scripts that allow using shared Attachments for various types of ER Objects (instead of duplicating them for each ER Object), and also support Relationships and Views.

read more

Macros – Add custom properties to specific objects

Sometimes, you may need to specify custom properties for various objects such as Entities, Tables, Attributes, etc.

The macros I’ll be sharing in this post, allow us to:
– Export the attachments from the current project
– Import attachments from an Excel Workbook
– Bind the attachments to specific objects (Entities, etc.).

read more

Macros – Colorize specific attributes

Using the data modeling features of ER/Studio Data Architect we can create automatic and customized data model diagrams. ER/Studio Data Architect provides functionality such as automatic layouts, custom colors and fonts for our objects, and relationship line control.
To make our model more attractive and easier to read, we can change the background, outline, and font colors along with the font type entities/tables, attributes/columns, views, and relationships in our data model. We can use specific colors and/or fonts to help us organize our data model.
In this blog post, I’ll share a macro which shows how to manage the colors from a script. With the macro, we can search for a string and colorize the attributes and columns which match the string.

read more