How can we help you today? How can we help you today?

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.
Gregory_Mellis
0

Comments

2 comments

Sort by
  • 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!
    Jessica R
    0
  • 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.
    Gregory_Mellis
    0

Add comment

Please sign in to leave a comment.