Is it possible to not deploy Descriptions of Tables and Cols

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Is it possible to not deploy Descriptions of Tables and Cols

Postby Alanb » Thu Mar 24, 2011 7:29 pm

We would like to source control our databases and to include the description fields within SQL . However we need to be able to create new production databases for deployment by our clients without the descriptions. Is this possible?
Alanb
 
Posts: 3
Joined: Thu Mar 24, 2011 7:16 pm
Location: London

Postby David Atkinson » Fri Mar 25, 2011 3:23 am

When you create a deployment script using SQL Compare, make sure the "ignore extended properties" option is enabled.

Please give this a go. If this doesn't behave as you expect, please let us know.

Kind regards,

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests