Likelihood to Recommend
Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms
Read full review
If you plan to use Redgate Data Compare to automate data change between tables or SCD or similar, this is not the software that is right for you, Data Compare is a software that performs simply (but in an optimal manner) the comparison of data between tables of different databases on different environments or clone or mirror databases even on the same environment or server. Once the data is compared, you can select or deselect each line you want to update and then have the data alignment script prepared for it.
Read full review Pros ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type. ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names. My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models. Read full review Simple and easy comparison of database data. Differences can be copied or synced from one database to another with a click of a button. You can save "projects" so that you can easily rerun a previous comparison whenever you need to. It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something. Read full review Cons ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running. The repository can be slow when the model count gets larger. By large I mean 20 to 30 models. A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two. Read full review Better License Management would be an improvement. Currently no way to manage your licenses without contacting your representative. Possibly better testing of backups would an improvement. Ability to restore files in a Sandbox would be a great feature. Read full review Support Rating
I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.
Read full review
Redgate is always fast to respond to any tickets I submit and provide fixes for any issues rapidly.
Read full review Alternatives Considered
ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.
Read full review
In the same way as the "twin" software (Redgate SQL Compare), this software has always proved to be perfectly functional, simple, fast and intuitive and it is for this reason that no other alternative software has been evaluated at Redgate Data Compare. I agree that looking for other software is always useful and is probably a best practice in some cases, but I am also of the idea that if a software does what it really says, it makes no sense to change it.
Read full review Return on Investment ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase. Read full review It's reduced errors and bugs associated with deploying new application features and forgetting to apply required database changes (or incorrectly applying them). It's made deploying new features a quicker task, eliminating the often laborious task of synchronizing data across databases. These sometimes complex queries and operations can easily be performed by any developer and don't require the involvement of a database administrator to perform. Read full review ScreenShots