COZYROC vs Redgate SQL Compare

Likelihood to Recommend

COZYROC is great if you have a number of sources or destinations where vanilla SSIS either does not provide connectors, they are difficult to work with, or they are not fully featured. SFTP is a prime example. Almost any web service is another. It also includes some nice helper components, such as script task plus. This speeds up the development of script tasks by making the configuration easier. That said, it is not a silver bullet for all your SSIS woes. I've found that none of the SSIS 3rd party components spans all my needs and generally end up running a couple of different ones to cover all the functionality required.

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 4 answers on this topic

We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release.On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.

Read full review

Kevin R. Zakoski

Database Engineer III

LTCGInsurance, 1001-5000 employees

View all 8 answers on this topic

Feature Rating Comparison

COZYROC

Redgate SQL Compare

Connect to traditional data sources

Connecto to Big Data and NoSQL

COZYROC

Redgate SQL Compare

Simple transformations

Complex transformations

COZYROC

Redgate SQL Compare

Metadata management

Business rules and workflow

Testing and debugging

COZYROC

Redgate SQL Compare

Version control tools

Performance optimization tools

Schema maintenance

Database change management

COZYROC

Redgate SQL Compare

User management

Database security

Change management

Pros

CRM Dynamics connection
Sharepoint list connector
SFTP component

Read full review

Verified User

Manager in Information Technology

Business Supplies & Equipment Company, 1001-5000 employees

View all 4 answers on this topic

Extremely fast!
Compares from source control, not just physical databases. No need to keep copies of databases of varying versions laying around.
Command line tools integrate easily into automated build processes.
Even has plugins for products like Octopus Deploy!

Read full review

Aaron Smith

Senior Software Developer

TimeTrak Systems, Inc.Computer Software, 11-50 employees

View all 8 answers on this topic

Cons

Looking for Office 365 API connector and source task.
Looking for Share Connection with multifactor login.

Read full review

Venkata Ramana Potluri

Database Analyst

Victorian Building AuthorityGovernment Administration, 201-500 employees

View all 4 answers on this topic

So far so good. I have to be honest, it's not a complicated application, and so far hasn't caused me any issues or to question the choices of the developers!

Read full review

Verified User

Manager in Information Technology

Retail Company, 201-500 employees

View all 8 answers on this topic

Usability

COZYROC 8.2

Based on 1 answer

Easy to use and easy to implement into ETL solutions with Microsoft SQL Server Integration Services.

Read full review

Verified User

Manager in Information Technology

Business Supplies & Equipment Company, 1001-5000 employees

View all 1 answers on this topic

Redgate SQL Compare 7.0

Based on 1 answer

It's a good tool to have, but becomes expensive to buy a user license for each developer.

Read full review

Verified User

Engineer in Information Technology

Insurance Company, 201-500 employees

View all 1 answers on this topic

Support Rating

COZYROC 8.6

Based on 4 answers

Their support is fast and responsive. Their devs work on resolving the issues quickly. We usually will have a release of a fix within a few days.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1001-5000 employees

View all 4 answers on this topic

Redgate SQL Compare 9.2

Based on 4 answers

They have a great community website where you can search for answers but are also very responsive when it comes to direct support.

Read full review

Verified User

Team Lead in Information Technology

Computer Software Company, 501-1000 employees

View all 4 answers on this topic

Alternatives Considered

We run both Task Factory and COZYROC. The two sets certainly have crossover but are also complementary. Neither solution provides coverage for every use case. We have also reviewed ZappySys, which again has significant crossover between the two, but some useful outlier functionality as well, such as a robust SOAP component if you have the misfortune of still dealing with that protocol.

Read full review

Verified User

Professional in Information Technology

Architecture & Planning Company, 1001-5000 employees

View all 4 answers on this topic

Honestly, I have never been interested in the usable alternatives. I have always been good to use it. The license cost after all has always been sustainable. I never had the idea of \ u200b \ u200bchanging it nor the need to look at other software. Also (always a redgate software) I use the Data Compare which is the "twin brother" for data check.

Read full review

Luca Campanelli

Senior Betting & Online DB Administrator

Intralot Italia S.p.A.- Gamenet GroupGambling & Casinos, 51-200 employees

View all 8 answers on this topic

Return on Investment

It helped us implement something impossible using original SSIS.
It helped us build the process more quickly.

Read full review

Verified User

Employee in Information Technology

Computer Software Company, 1001-5000 employees

View all 4 answers on this topic

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 schemas and 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

Richard Davies

Senior Web Application Developer

City of PortlandGovernment Administration, 5001-10,000 employees

View all 8 answers on this topic

Pricing Details

General

Free Trial

Yes

Free/Freemium Version

Yes

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

No

COZYROC Editions & Modules

Edition

COZYROC SSIS+ Ultimate Subscription	$899¹
COZYROC SSIS+ 1.9 Lifetime	$4,999²
COZYROC SSIS+ Premium Priority Support	499.95³
COZYROC SAS® SSIS Adapters	2,499.95³
COZYROC Excel Add-in for SAS®	199.95³

year
one-time payment
year

Additional Pricing Details

COZYROC SSIS+ Ultimate Subscription - $799 /per year 2 license keys (for two servers) * Free upgrades to newer versions * Free to use in Visual Studio * Premium support (Priority over regular free support. Guaranteed one business day response time.)

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Redgate SQL Compare Editions & Modules

—

Additional Pricing Details

—

Rating Summary

COZYROC

Redgate SQL Compare

COZYROC

Redgate SQL Compare

COZYROC

Redgate SQL Compare

Likelihood to Recommend

COZYROC

Redgate SQL Compare

Feature Rating Comparison

Connect to traditional data sources

Connecto to Big Data and NoSQL

Simple transformations

Complex transformations

Metadata management

Business rules and workflow

Testing and debugging

Version control tools

Performance optimization tools

Schema maintenance

Database change management

User management

Database security

Change management

Pros

COZYROC

Redgate SQL Compare

Cons

COZYROC

Redgate SQL Compare

Usability

COZYROC

Redgate SQL Compare

Support Rating

COZYROC

Redgate SQL Compare

Alternatives Considered

COZYROC

Redgate SQL Compare

Return on Investment

COZYROC

Redgate SQL Compare

Screenshots

COZYROC

Redgate SQL Compare

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

COZYROC Editions & Modules

Edition

Additional Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Redgate SQL Compare Editions & Modules

Additional Pricing Details

Rating Summary

Add comparison