Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database Deployment using SSDT Expand / Collapse
Posted Friday, February 1, 2013 4:39 AM



Group: General Forum Members
Last Login: Yesterday @ 3:24 AM
Points: 1,575, Visits: 1,533

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.

Post #1414569
Posted Monday, March 11, 2013 10:18 PM


Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 134, Visits: 402
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 »

Add to briefcase

Permissions Expand / Collapse