What are the challenges you face when working across database platforms? Take the survey

Use Drop and Create Instead Of Alter Option

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.

Best Answer


  • Options
    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.
Sign In or Register to comment.