N_Muller
Reputation: 51
SSDT doesn't recognize changes to table to make it a partitioned table
I have a table in SQL Server 2014 with the definition in TFS (VS-2015). The table is not partitioned. I made the table partitioned in TFS and expected SSDT would recognize the change and create a deployment script that would change the table from non-partitioned to partitioned. That didn't happen.
Is there a workaround other than making the table changes outside of TFS and SSDT?
Upvotes: 3
Views: 515
Answers (1)
Piotr Palka
Reputation: 3169
Uncheck "Ignore object placement on partition schemes" in your deployment settings (it is set by default):
Upvotes: 2
Related Questions
- Can I ALTER a partitioned table in SQL Server 2005?
- Altering/Editing an already partitioned table
- Creating SSAS Tabular Partitions in SSMS is not reflected in SSDT solution
- Renaming a table on Visual Studio SSTD project always crates a new table.
- SSDT implementation: Alter table insteed of Create
- SSDT - Ignoring partition function changes
- Alter A Partitioned Table Column DataType
- Sql Server 2005 - Add partition scheme to a non partitioned table
- SQL Server Partitioned Tables - how to sync table definitions?
- Partitioning non-partitioned table in SQL Server 2008