Thursday, 15 August 2013

Moving data services repositories

We recently moved out repositories from one SQL server to another.  We have no end of problems and are still finding little issues.  So I thought it would help others if I posted a few tips:

  1. Before starting, make sure everything is checked into the central repository.
  2. For local repositories, you are better off to create new one's on the destination server, and remove the old ones.
  3. Ensure that you have everything correct in IPS/BO before worrying about the job server designer.
  4. If you get errors trying to add repositories into the job server, you will need to change the job server name.  One the repos are added, just change it straight back.  This seems to be a bug in the job server manager.

I hope these help !   If I knew this before we stared, I would have had a much easier few weeks !