Solved

Migrating Altiris Deployment server database to another SQL server

Posted on 2010-08-26
4
2,029 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
Invest in your employees with these five simple steps to improve employee engagement and retention.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

691 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