May 2, 2011

Partner of the Month: Red Gate Software

Integration

This is the first article in a series about Perforce's integration and technology partners. Expect to see future article in this series about once a month.

Background

Red Gate Software makes SQL Source Control. Red Gate joined Perforce's integration program earlier this year.

Tell us a little bit about your company and your product

Red Gate Software produces ingeniously simple tools for over 500,000 Microsoft technology professionals worldwide. We currently specialize in MS SQL Server, Oracle, and .NET tools. Our tools are used in many of the world's leading companies, including Microsoft, HP, Sage, Bank of America, AT&T and the US Treasury.

Link database to source control
Link database to source control

Our newest SQL Development tool, SQL Source Control, allows organizations to connect their existing source control system, such as Perforce, to SQL Server.

What benefits do we get from integrating your product with Perforce? Describe any key technical challenges that are solved.

Application development, unlike SQL development, has always been developed in a source controlled environment. It is best practice to do so. In fact it would be irresponsible to not develop applications in a source controlled environment. Up until now, source controlling your SQL Server has required lots of painful manual scripting and considerable resource overhead. The Red Gate installation process allows a SQL Server to be linked to source control in under five minutes. This brings all the benefits of working in a source controlled environment to SQL Server. Perforce, as a well-established and reputable player in the SCM market, has a segment of users who have significant overlap with SQL Server development, and therefore providing the integration was a no-brainer decision for Red Gate.

Who would benefit most from using your product with Perforce? Developers, product managers, administrators?

Both SQL DBAs and Developers will benefit as long as they make schema or stored procedure changes as part of their role. Managers as well as DBAs can benefit from the audit trail. Standards and compliance are satisfied. SQL developers and DBAs can work smarter with improved quality and confidence with greatly reduced development times. SQL developers can easily share changes and work on the latest version of the development database with confidence and improved efficiency. As both the shared (where the team works off a central shared database) and the dedicated (where each developer has their own sandboxed local version of the database) development models are supported you won’t have to change the way you work. Before pushing changes up the database development chain, DBAs can see an audit trail of who changed what, when and why. This is particularly useful if you have any compliance regulations that require an audit trail of SQL Development.

Describe your experience integrating your product with Perforce. Was it relatively simple?

Very simple – less than 5 minutes from downloading the 28-day free trial from red-gate.com to linking with Perforce.

Please share any insights you have on effectively using your product with Perforce.

All the benefits of source control are unlocked for database development when integrating with Perforce, such as easy team collaboration, conflict resolution, branching, merging, auditing, and even building a database as part of a continuous integration process.

Anything else you’d like to share with us?

Want to see the tools in action? Free webinars are available, as well as a 28-day free trial.