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
Author
Message
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: Tuesday, July 22, 2014 3:20 AM
Points: 1,138, Visits: 808
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
Posted Monday, March 11, 2013 10:18 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 6:00 PM
Points: 97, Visits: 315
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