Use Drop and Create Instead Of Alter Option

Gregory_Mellis

I am running the latest Update version of SQL Compare and I don't think this is working correctly.
I have 2 tables where I changed several Column Length's. The Resulting Update Script contains statements like this ALTER TABLE [dbo].[Customer] ALTER COLUMN [ShipToName] [nvarchar] (30) NOT NULL
I was expecting to get an Drop and Create Script, where I can then modify the Data Copy process to peform LEFT Truncation.

Jessica R

Hi and thanks for your post!

The "use drop and create instead of alter" option actually only applies to the following object types (as described here):

Views
Stored Procedures
Functions
Extended Properties
DDL Triggers
DML Triggers

If you'd like to see this option to apply to tables as well, can you please vote on the request here: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3554275-include-tables-in-use-drop-and-create-instead-of

Thank you and sorry for any confusion on this!

Gregory_Mellis

Thanks Jessica, I found the Note on the side of the UI, I suspect in the past a lot of the Table changes I make force the rebuild because I also insist on the Table Retaining its Column Sequence and I am a stickler for my Create/Update Audit Stamps always being the last 4 Columns of the table.