ER/Studio Data Architect vs. Redgate SQL Data Compare

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
ER/Studio Data Architect
Score 9.9 out of 10
N/A
ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.N/A
Redgate SQL Data Compare
Score 8.2 out of 10
N/A
N/AN/A
Pricing
ER/Studio Data ArchitectRedgate SQL Data Compare
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
ER/Studio Data ArchitectRedgate SQL Data Compare
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
ER/Studio Data ArchitectRedgate SQL Data Compare
Considered Both Products
ER/Studio Data Architect
Chose ER/Studio Data Architect
ER/Studio was difficult to learn at the beginning, but that was 7 years ago. I have used it across many companies since then, and It is really easy to use. I found it much easier to learn than Erwin as well.
Redgate SQL Data Compare

No answer on this topic

Top Pros
Top Cons
Features
ER/Studio Data ArchitectRedgate SQL Data Compare
Database Development
Comparison of Database Development features of Product A and Product B
ER/Studio Data Architect
-
Ratings
Redgate SQL Data Compare
7.3
4 Ratings
13% below category average
Version control tools00 Ratings7.01 Ratings
Test data generation00 Ratings5.01 Ratings
Performance optimization tools00 Ratings8.01 Ratings
Schema maintenance00 Ratings7.01 Ratings
Database change management00 Ratings9.63 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
ER/Studio Data Architect
-
Ratings
Redgate SQL Data Compare
9.5
4 Ratings
11% above category average
Database status reporting00 Ratings10.01 Ratings
Change management00 Ratings9.03 Ratings
Best Alternatives
ER/Studio Data ArchitectRedgate SQL Data Compare
Small Businesses
AWS CloudFormation
AWS CloudFormation
Score 8.4 out of 10
DBeaver
DBeaver
Score 9.2 out of 10
Medium-sized Companies
AWS CloudFormation
AWS CloudFormation
Score 8.4 out of 10
ER/Studio Data Architect
ER/Studio Data Architect
Score 9.9 out of 10
Enterprises
AWS CloudFormation
AWS CloudFormation
Score 8.4 out of 10
ER/Studio Data Architect
ER/Studio Data Architect
Score 9.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
ER/Studio Data ArchitectRedgate SQL Data Compare
Likelihood to Recommend
8.0
(5 ratings)
10.0
(4 ratings)
Support Rating
9.0
(2 ratings)
10.0
(4 ratings)
User Testimonials
ER/Studio Data ArchitectRedgate SQL Data Compare
Likelihood to Recommend
Idera Software
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
Redgate
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
Idera Software
  • 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
Redgate
  • 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
Idera Software
  • 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
Redgate
  • 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
Idera Software
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
Redgate is always fast to respond to any tickets I submit and provide fixes for any issues rapidly.
Read full review
Alternatives Considered
Idera Software
ER/Studio is the most mature, reach in features and quality and therefore useful. Unfortunately, it lacks compatibility with AWS Redshift.
Read full review
Redgate
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
Idera Software
  • 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
Redgate
  • 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