Posts Tagged with SQL Compare

Streamlining database deployments with SQL Compare

When I attended PASS Summit recently, I sat down with Chris Yates, Assistant Vice President and Database Administration Manager of Republic Bank, to understand more about their day-to-day development tasks and how Redgate tools have helped improve their development practices. This is their story. “In a previous life, SQL Server database comparisons and deployments... read more

How to build multiple database versions from the same source: object filters

I’ve worked with several companies who maintain databases in multiple data centers, each one holding the data for a particular region, and each database serving multiple applications. Over time, for various business or legal reasons, it often becomes necessary to apply updates to certain individual data centers. The right, but hard, way to do... read more

How to compare two DacPacs using SQL Compare

Often during my development work, especially at the Proof-of-Concept (PoC) stage, I need a quick and easy way to save my current progress, for example, by updating a set of object build scripts in a directory. Ultimately, I also need a way to compare my current development database or script directory to a target... read more