Renamed Fields

SLarkin

I'm trying to use SQL Compare (v.13.6.1.7928) to generate deployment scripts for updating a set of tables based on a DDL script from the vendor. The vendor has changed some of the field names (don't get me started), and instead of adding the new-named column, I'd like to update the existing column, but I don't see a way of telling SQL Compare that this is what I want to do on a case-by-case basis. 

Is there a property or setting that I'm not seeing, or does anyone have a suggestion on how to solve my problem programmatically? I'd like to avoid doing this manually for 300 tables, if possible. This is a SQL Server 2014 db.

Sergio R

In most cases SQL Compare will already do this automatically, and will use the EXEC sp_rename command, I have tested this with the very latest version (13.7.4), but the behavior should be identical in the version that you are using:

<div>PRINT N'Altering [dbo].[T1]'

</div><div>GO

</div><div>IF @@ERROR <> 0 SET NOEXEC ON

</div><div>GO

</div><div>EXEC sp_rename N'[dbo].[T1].[C2]', N'C4', N'COLUMN'</div>

If this isn't happening in your case, please post some reproduction steps.

There might be some SQL Compare options that change this behavior, apart from that the only way to do this would be to create a deployment script and then update the script manually.