Red Gate forums :: View topic - Suggestion or help
Return to www.red-gate.com RSS Feed Available

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

Suggestion or help

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
dbell



Joined: 08 Nov 2004
Posts: 3

PostPosted: Sat Dec 06, 2008 1:57 am    Post subject: Suggestion or help Reply with quote

Is there an option or way to export the SQL script from SQL Doc2? It'd be of great use on my current project. Cutting and pasting table by table isn't really a good thing.
Back to top
View user's profile Send private message MSN Messenger
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Sat Dec 06, 2008 12:12 pm    Post subject: Reply with quote

Hello,

Thanks for your post and getting in touch. There is not a way to export the sql scripts from SQL Doc 2, however you can using SQL Compare and the Scripts to Folder feature.

SQL Compare can be downloaded from http://www.red-gate.com/products/sql_compare/

If you have any other questions, please let us know.

Thanks

Ben
Back to top
View user's profile Send private message
dbell



Joined: 08 Nov 2004
Posts: 3

PostPosted: Sun Dec 07, 2008 6:45 pm    Post subject: Generating extended properties script Reply with quote

Thanks for getting back to me so quickly. Offering the ability to generate the extend properties as script would be an excellent feature then.
Currently though not attractive, we'd have to cut and paste the generated SQL in the documentation, since comparing with SQL Compare will find other things we aren't interested in at that point. But you don't seem to offer the option to only extract the extended properties of the database, and even further the ability to filter which extended properties we'd want.
We have some that do not pertain to documentation.

We have a large database an a single person is dedicated only to documenting it and that person isn't the designer. Having a script where the database object is checked for existence and if found the extended property applied would really round out this product. With this the script can be applied to any of our developer's database sandboxes and be of great benefit.
Back to top
View user's profile Send private message MSN Messenger
alex.weatherall



Joined: 29 Nov 2005
Posts: 42

PostPosted: Fri Jan 09, 2009 4:11 pm    Post subject: Reply with quote

I agree, this would be a useful feature as we want to maintain the documentation on "documentation" databases in a development area - not necessarily in the live database. So to be able to generate a script of the properties created by SQLDoc would be useful.

Or do you know another way of quickly scripting the extended properties only in a database (I tried playing with the SSMS script options, but this didn't seem to be possible)

If I find a usable alternative method I will post the results here.

Thanks

Alex
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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