Tag Archives: SQL Compare

Using SQL Compare to Revert a Stored Procedure

Posted on August 13, 2025 by way0utwest

Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do you fix this? We’ll use SQL Compare since most of you … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using SQL Compare to Revert a Stored Procedure

Comparing My Current Schema with a Backup with SQL Compare

Posted on March 31, 2025 by way0utwest

A customer asked if they needed to restore a database from backup to compare the schema in a database. They don’t and this post shows that. This is part of a series of posts on SQL Compare. Setting Up a … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Comparing My Current Schema with a Backup with SQL Compare

Using SQL Compare with Read-only Access

Posted on November 20, 2024 by way0utwest

Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some tools that create temp tables or do some other work in … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Using SQL Compare with Read-only Access

Using SQL Compare in Read-Only Databases

Posted on October 21, 2024 by way0utwest

Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some tools that create temp tables or do some other work in … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment