Database Change Management
Database Change Management
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?




 All Forums
 Support
 DB Ghost Support Forum
 Sql Server lock levels when scripting DB?
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

LtMandella


5 Posts

Posted - 06/02/2015 :  17:59:43  Show Profile Send LtMandella a Private Message  Reply with Quote
Hi Folks,
I did a few searches of the help with no luck.

I'd like to occasionally script out some of our DB objects during business hours when DB is in use. I am concerned however about the level of locking involved while the tool is generating DB scripts.

Can you advise? I assume schema locks are one type of lock happening during script generation?

thanks,
Ken

Google AdSense

USA
Mountain View


dbghost



66 Posts

Posted - 06/03/2015 :  05:01:01  Show Profile  Visit dbghost's Homepage Send dbghost a Private Message  Reply with Quote
The design of the scripting process assumes is that no one is changing the objects or data while DBG is scripting. DBG therefore uses minimum or no locking when scripting. Scripting assumes the operator has started the scripting process at a sensible point in time.

To script the database objects DBG queries the schema information which this should not have much impact on users who are querying the business data or running stored procedures etc.


Go to Top of Page

LtMandella



5 Posts

Posted - 06/03/2015 :  19:53:08  Show Profile Send LtMandella a Private Message  Reply with Quote
@dbghost

excellent, I think that makes perfect sense to not employ schema locks during scripting out.

Just wanted to check.

Thank you for the fast response, and excellent product!
ken
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Jump To:
Database Change Management © Copyright 2005 Innovartis Ltd. Go To Top Of Page
Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA - Privacy Policy
ForumCo Free Blogs and Galleries
Signup for a free forum or Go Banner Free