Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSDT - Ignoring partition function changes

I'm trying to publish a database project, which also contains a partition function. My destination databases have different (date) values which I do not wish to modify, although SSDT/SqlPackage always attempts to re-create the Partition Function and needless to say - all tables that use the PF.

I have checked the following options: IgnoreObjectPlacementOnPartitionScheme & IgnorePartitionSchemes (http://msdn.microsoft.com/en-us/library/aa833291(v=vs.100).aspx) but still getting the recreation attempt.

Running both VS2012 (latest SSDT) and VS2013

I've attached a sample project to demonstrate the behavior: http://www.fast-files.com/getfile.aspx?file=73666

like image 914
0xAD Avatar asked Apr 02 '14 00:04

0xAD


1 Answers

I think I've managed to get this resolved - Seems like VS UI ignores the "Ignore Partition Scheme" checkbox, however, when specifying in SqlPackage manually it works. Added this to a SqlPackage execution: /p:IgnorePartitionSchemes=True

Hope it helps whoever got stuck on the same issue

like image 99
0xAD Avatar answered Oct 19 '22 02:10

0xAD