Tag Archives: SQL Compare

Deploying an Updated Model with SQL Compare 16

In a previous post, I deployed a model to a database using SQL Compare 16. This used a new feature in that connects to Redgate Data Modeler. In this post, I want to update my model, and again use SQL … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Using SQL Compare with Redgate Data Modeler

Redgate recently released SQL Compare v16, which included a new feature to work with Redgate Data Modeler. I decided to give it a try in this post. I’ll take a model and compare it to a database, and deploy my … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Using SQL Compare to Revert a Stored Procedure

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

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