Red Gate forums :: View topic - Only one field description change allowed
Return to www.red-gate.com RSS Feed Available

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

Only one field description change allowed

Search in SQL Doc 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
krayl



Joined: 25 Aug 2014
Posts: 2

PostPosted: Mon Aug 25, 2014 7:45 pm    Post subject: Only one field description change allowed Reply with quote

I am updating the field descriptions.
In the 3.0 version, I make a change to the text. Then I update a second description. Now there are 2 sets of icons that will either update the text or delete. I select to update the description thinking that this will perform better than the previous version and update all changes in the database. Instead the entire panel showing the table hangs with no other updates allowed until I select a different table and reselect the original table.
I started this in version 2 of SQLDoc where I was able to make multiple updates to the table prior to updating the database with all changes.
This new version makes SQLDoc completely inefficient and unusable.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Thu Aug 28, 2014 3:22 pm    Post subject: Reply with quote

I'm sorry that SQL Doc doesn't seem to be performing well. Updating the description runs a query on the database that updates an extended property on the database that you are documenting. it should be fairly quick, but it sounds like the SQL Server is not processing the query in a timely fashion. Is this behavior evident on all databases and servers, or just one?
Back to top
View user's profile Send private message
krayl



Joined: 25 Aug 2014
Posts: 2

PostPosted: Thu Aug 28, 2014 7:13 pm    Post subject: Reply with quote

I don't think I am being very clear.

SQLDOC2 allowed the user to make multiple edits to the table or field descriptions and apply all of the edits at once.

SQLDOC3 [b]only [/b]allows the user to make 1 edit per update and then locks up after the update until selecting another table or object.

This is the case on every instance and database that I have accessed.
Back to top
View user's profile Send private message
alientresor



Joined: 31 Aug 2014
Posts: 1

PostPosted: Sun Aug 31, 2014 9:08 pm    Post subject: SQL Doc + MSSQL 2014 = hangs out + save only one item Reply with quote

I've got exactly the same problem, in previous versions I was able to create documentation in 1-2 days.
Now with these problems it is almost impossible to create any docs Sad

Hope You will fix it.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Wed Sep 10, 2014 8:11 am    Post subject: Reply with quote

Can you please clarify "multiple edits"? I do not fully understand what/where you are editing. Is this about editing extended properties directly on the SQL Server?

As SQL Doc is almost completely rewritten for v3 it would not be possible to simply go through SQL Doc's code and compare to see what has changed and solve the problem that way. So from my perspective I have to throw away comments about how it used to work in the previous version and concentrate on what/where the problem is in this version, try to reproduce it, and pass the reproduction on to development so they can do whatever they do.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Mon Sep 15, 2014 9:57 am    Post subject: Reply with quote

In SQL Doc 2, when you edit an extended property (description) on a column, it opened a dialog where you could save the change or cancel. I do not see the ability to edit and save multiple extended properties at one time.

If SQL Doc 3 is "hanging" when attempting to edit the extended property, can we please identify that as the issue as there is more chance of getting that fixed than "rolling back" a UI change that has been determined to make a cleaner, more usable UI.
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