Posts Tagged with SQL Compare

1 August 2017

1 August 2017

A whole new way to see differences in SQL Compare

In the latest release of SQL Compare, we’ve added a brand new way to examine the differences between two objects in your database. Until now, SQL Compare has relied on the SQL difference viewer to convey the differences between an object in the source database and its counterpart in the target database: Don’t worry,... Read more

17 March 2017

17 March 2017

How to use custom filters in SQL Compare

I used to work at JD Edwards, and in one of our ERP products we had a cumbersome database schema. There were tables like this: These were the tables that held various information in the system. Trying to find data was an exercise in frustration, even for those of us that were familiar with... Read more

15 March 2017

15 March 2017

Time travelling with SQL Compare

In SQL Server 2016, Microsoft introduced support for system-versioned temporal tables. Temporal tables are a database feature that provides information about data stored at any point in time, rather than only the data that is correct at that specific moment. Why are temporal tables needed? Simply put, they make it much easier to analyze... Read more

Eliminating ‘noise’ from database deployment scripts using SQL Compare project options

A database comparison tool like SQL Compare removes a lot of the pain behind the task of comparing SQL Server database schemas, generating a synchronization script, and then deploying the changes from the source to the target database. However, depending on how you have SQL Compare configured, there may still be some manual work... Read more

2 February 2017

2 February 2017

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