Database Deployment using SSDT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL Server 2012 - T-SQL » Database Deployment using SSDT

Database Deployment using SSDT

Rate Topic

Display Mode

Topic Options

Author

Message

Andrew Pruski

Posted Friday, February 01, 2013 4:39 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 6:37 AM
Points: 841, Visits: 495

Hello,

We recently have been using the December release of SSDT to script out a database deployment and noticed that the script generated DROP and the CREATE statements for tables, even though the table structure was not being changed.

We resolved this by dropping the clustered index on the table but I am keen to find out why this would be an issue.

Has anyone else run into this problem?

Any advice would be most appreciated.

Andrew

Post #1414569

murdakillemall

Posted Monday, March 11, 2013 10:18 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:12 PM
Points: 59, Visits: 220

I'm not quite sure why it does that but I noticed that also.

I now make it a habit to review the code before any changes and getting rid of "risky" stuff like unnecessary drops and creates. At least in the code I've seen, it always seems to create a table with a temp name with the same or new schema (I think it does this blindly), copies the data to the new table, then drops the old table, and lastly renames the new table with the old table name.

Post #1429571

« Prev Topic | Next Topic »

Permissions