title: Best Practices for Deploying SQL Server Projects (SSAS, SSIS, SSRS) across domains
body: <p>Scenario:</p>
  
  <ul>
  <li>Production servers are running SQL Server 2008 in the domain myDomain.com</li>
  <li>Dev/test/stage servers are running SQL Server 2008 in the domain dev-myDomain.com</li>
  <li>Actual dev work done on local running SQL Server 2008 source controlled using SourceSafe</li>
  </ul>
  
  <p>First of all, does this setup/environment make sense? And, what are some good ways of deploying projects including SSAS, SSIS, SSRS from local to the dev servers and finally into live?</p>
  
  <p>Is including the output (compiled) files in SourceSafe and deploying from there good practice? If it is any ideas?</p>
  
  <p>Or, is going straight from Visual Studio without having the output in SoureSafe better?</p>
  
  <p>Thanks.</p>