5

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

0xAD
  • 141
  • 2
  • 10
  • What is your reasoning for having different schemas on different environments? – Joe Phillips Apr 25 '14 at 16:04
  • These are not different schemas, only different partition function values. In prod we have a running "sliding window" which changes the date values every month. The Database project is not affected by these changes. – 0xAD Apr 25 '14 at 18:13

1 Answers1

9

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

0xAD
  • 141
  • 2
  • 10