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

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 1,416, Visits: 1,245

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: Tuesday, March 24, 2015 12:24 PM
Points: 134, Visits: 362
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