Red Gate forums :: View topic - Extract SQL to add or update the properties
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

Extract SQL to add or update the properties

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mrekdal



Joined: 08 Mar 2008
Posts: 2

PostPosted: Sat Mar 08, 2008 11:21 pm    Post subject: Extract SQL to add or update the properties Reply with quote

I would like to do documentation on one database, and then reapply the same documentation to another instance, i.e. add the extended properties there as well. Is that possible, without a lot of manual cut and paste?
_________________
Magne Rekdal, MD
Consultant, Norwegian National Diabetes Register
Managing Director, Emetra AS
Back to top
View user's profile Send private message
chris.buckingham



Joined: 30 Jul 2007
Posts: 56

PostPosted: Tue Mar 11, 2008 3:47 pm    Post subject: Reply with quote

The best way I think to do this is after you have made your changes to Database A, run a SQL Compare between Database A and an empty database. You will obtain a synchronisation SQL script which you can extract and process - you can run through this script extracting all the lines containing 'sp_addextendedproperty' and insert them to another SQL script (you could write a simple VB application to do this for instance, or use a Perl command). This SQL script in SSMS would then write the extended properties onto Database A for you.

Running SQL Compare then between Database A and Database B would obtain another SQL script that you could process in a similar way, and run that against Database B, and synchronise them.

The alternative would be to write a Toolkit application, extracting and running only the lines containing 'sp_addextendedproperty'
_________________
Chris Buckingham
Red-Gate support
Back to top
View user's profile Send private message Send e-mail
rrussello



Joined: 30 Oct 2008
Posts: 2

PostPosted: Thu Oct 30, 2008 8:44 pm    Post subject: Extract SQL to add or update the properties Reply with quote

I would also like to see an 'export' feature added to a future release to SQL DOC. This was a deciding factor on my company's purchase of a SQL Documentation tool. Since no other tools offer this feature, and we already have a license for SQL Compare we decided to stay within the RedGate Family. We would also like to have documentation on one database and reapply it to another database with the same schema.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Thu Oct 30, 2008 11:53 pm    Post subject: Reply with quote

Hi,

Have you considered using SQL Compare to transfer the object descriptions across? They are just extended properties so will be identified as differences when you compare the two schemas, as long as you make sure you haven't ignore extended properties in the options.

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
rrussello



Joined: 30 Oct 2008
Posts: 2

PostPosted: Fri Oct 31, 2008 1:44 pm    Post subject: Reply with quote

Yes I have used SQL Compare and it works very well for getting a script to update a live production database. We also are using the initial script to add the extended properties into a new database for a customer. Using SQL Compare generates a script of about 2000 lines that we trigger upon creation of the new database. If our schema changes this script will fail, and the new database would not contain the documentation. If SQL Doc had a feature to export the extended properties we would not have the problem of maintaining an initial script upon a new database creation. Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group