Solved

Migrating Altiris Deployment server database to another SQL server

Posted on 2010-08-26
4
1,961 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

As a long-time IT Professional, the most important skill I have developed and consider to be my most valuable tool is Effective Troubleshooting. Step through my problem-solving procedure in this 10-step guide adapted from The Universal Troubleshooti…
You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

914 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now