Moving a Designer database between farms

You can move a Designer database, version 12.0.x from one farm to another. One of the reasons why you would move your database is if you have a production database that you want to modify and test in a test environment.

  1. In Microsoft SQL Server Management Studio:
    1. Create a copy of your Designer database.
      You can, for example, create a back up of your database.
    2. Restore the database with a new name.
    3. Navigate to the restored Designer database, and edit the tlbSystemProperties table.
    4. Clear values for these IDs:
      • COSAPM
      • COSProject
      • FarmOLAP
      • FarmProfileName
  2. Start Designer.
  3. Register the restored Designer database.
  4. Register the database in a farm repository.
Related topics