4

With a VS2012 database project can I make it ignore column order when publishing and just add the columns to the end of the table? This is a faster and safer option.

Craig
  • 36,306
  • 34
  • 114
  • 197

2 Answers2

1

I don't think there's currently a way to do this with Visual Studio 2012. There is supposed to be an "Ignore column order" option in the advanced deployment settings but this option has been removed according to this page. Apparently the scope of this option was confusing and Microsoft has decided to remove it until they can improve it. (The page actually claims this option was removed from SQL Server Data Tools but I believe that is wrong. I have confirmed this option exists in Visual Studio 2010 with SSDT so I believe the problem is really with VS 2012.)

For Visual Studio 2010 you'll find the setting as follows.

  • When using the Publish option: Publish > Advanced > Ignore column order
  • When using the Deploy option: Project properties > Debug tab > Advanced > Ignore column order
Keith
  • 20,636
  • 11
  • 84
  • 125
  • I had a look and can't see and 'Ignore Column Order'. – Craig Dec 07 '12 at 10:09
  • Sorry Craig, I just discovered that this option is missing in VS 2012. I have updated my answer accordingly. Without that option I'm not sure how you can achieve what you're trying to do. – Keith Dec 07 '12 at 16:29
  • This option is not available. You can vote for it here https://connect.microsoft.com/SQLServer/Feedback/Details/1221587 – Rory Jul 13 '16 at 11:40
0

This question appears to be a duplicate of this one. I believe this StackOverflow answer provides the information you are looking for.

deadlydog
  • 22,611
  • 14
  • 112
  • 118