Solved

Migrating Altiris Deployment server database to another SQL server

Posted on 2010-08-26
4
1,994 Views
Last Modified: 2012-08-13
Hello,
I am trying to Migrate Altiris Deployment server (SQL) database to another SQL server.
Does anyone have experience of doing this as I can't even see an option to change where Altiris gets the data from?
We are using Altiris Deployment Server version 6.9 Sp 4
If anyone has any experience of this please let me know.
Thanks, Ryan.
0
Comment
Question by:MSSC_support
  • 2
4 Comments
 

Author Comment

by:MSSC_support
ID: 33529279
The database currently sits on a SQL 2005 database on the same server as Altiris DS.
We have actually already taken a copy of the database & imported it into a new SQL 2008 server - However our problem is with Deployment Server itself - we don't know how to tell the program to point elsewhere to pick up it's database?


0
 
LVL 15

Accepted Solution

by:
MohammedU earned 500 total points
ID: 33537240
In your Altiris programm you should have an option to change the datasource.
If you can't figure it out, try renaming the old server with suffix _old and new server to the same name as old server.
Old Server:
Rename the server and change the ip address some thing else...flush the dns and reboot...
New Server:
Rename the server and change the ip address as same as old one then reboot...you should be back in business..
0
 

Author Closing Comment

by:MSSC_support
ID: 33732421
Good and useful
0
 

Expert Comment

by:dtran67
ID: 34301837
I am having the same issue.  In our case, the current SQL server is different from our deployment server.  We want to move to a new SQL server.  I am not able to find anywhere in Altiris to change the datasource.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How can you create a game plan that lets you focus on special projects instead of running from cubicle to cubicle every day and feeling like you’ve accomplished nothing? Try these strategies for prioritizing your tasks, offloading what you can, and …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

860 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