Script needed for a major database move project

Posted on 2007-10-16
Last Modified: 2013-12-18
We're moving a few hundred databases from one server to another.  Does anyone have any script that will assign the new server as the administration server and remove the old server from each of the databases involved?  Also, need script that will update the ACL on the new server w/appropriate groups and roles.  
Question by:kat64
    LVL 63

    Expert Comment

    LVL 63

    Expert Comment

    Admin server can be changed for multiple items via the Admin Client in the Files view.

    I hope this helps !
    LVL 31

    Accepted Solution

    If you are using a current version of Domino, there are very good database move facilities built in.  You can move a mass of databases fromm one srever to another, and ACL issues are automatically handled.  You may still want to do the group management described below.

    If you must process them manually, here's what you can do:

    Groups -- you will have to check what groups the old server belonged to, and add the new server to those.  Your directory admin server should have the directory full text indexed, so you can go to the groups view on that server, and full text search on the old server name.  Edit each one, and paste in the new server name as a member.  Not much point in scripting this piece, unless you have 100 or more found in the search.  You shoudl not need to make any other group updates, because the existing gorups should still be good now that you have added the new server wherever the old server appeared.

    Adding server to ACL -- here's a problem.  Theres no easy way to tell what the admin server is for each database. This is where you probably need some LotusScript. The same script could cover cases where the old server is not admin server but is explicitly listed in the ACL.

    Roles -- where serevr is listed by group, that's covered by the group changes above.  Where the server is listed in the ACL explicitly, the LotusScript shoudl take care of it.

    One last note.  You talk about adding the new server in and removing the old one.  Is that necessary? You usually need a transition, where bloth servers are in the ACL.  Then, with the old server decomissioned, is there any harm in leaving the old server name around? Or even if it is not deocmissioned?

    Script: I can write one, but again, I don't think that's necessary.  Use the built in process. The script structure would be:

    Get a list of all databases on the old server
    Check ACL for each one
    If old server is in ACL, make new entry mimicing it - which includes setting the same entry type, entry level, entry roles, and if the old server was admin server, removing the amdin server role and adding it to the new server

    Note that you should create the new replicas immediately before or after doing this, depending on whether this process is needed to even grant access to the new server. If you create the replicas much later, you risk misisng admin processes running, e.g., if a user is renamed in the interim.
    LVL 20

    Expert Comment

    I agree with qwaletee, I would use the built-in process. One other thing to consider is scheduled agents in any of these databases. Sometimes the servers are listed explicily in the schedule properteis and this will cause the agent to fail if it is not changed.
    LVL 31

    Expert Comment

    Database move process is also supposed to handle agent $MachineName assignment.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now