<div>
The database currently sits on a SQL 2005 database on the same server as Altiris DS.<br />
We have actually already taken a copy of the database &amp;&nbsp;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? <br />
<br />
<br />

</div>


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?




<div>
I am having the same issue. &nbsp;In our case, the current SQL server is different from our deployment server. &nbsp;We want to move to a new SQL server. &nbsp;I am not able to find anywhere in Altiris to change the datasource.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hello, <br />
I am trying to Migrate Altiris Deployment server (SQL) database to another SQL server. <br />
Does anyone have experience of doing this as I can't even see an option to change where Altiris gets the data from? <br />
We are using Altiris Deployment Server version 6.9 Sp 4<br />
If anyone has any experience of this please let me know.<br />
Thanks, Ryan. <br />

</div>
</div>


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. 


Migrating Altiris Deployment server database to another SQL server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

IT Administration is the processes and best practices for programming and development, and incorporates methodologies for managing activities and projects. Common methodologies include waterfall, prototyping, iterative and incremental development, spiral development, rapid application development, extreme programming and various types of agile methodology. The life-cycle "model" is a more general term for a category of methodologies, and a software development "process" a more specific term to refer to a specific process chosen by a specific organization.