How to move Demand Planner database to another server

Sometimes you need to move your existing Demand Planner database to another server. If you do this just using backup/restore, you will run into the issue while synchronizing the Demand Planner. The error you get is: Could not find ‘server name’ in sys.sysservers This is because Demand Planner uses fully qualified object names in some…