<div>
<div class="content wysiwyg-content">
When doing a side-by-side upgrade or migration of MS SQL Server 2005 to MS SQL Server 2012 can one or should one backup the MS SQL Server 2005 System DBs and do a restore of those to the clean MS SQL Server 2012 installation to facilitate the migration process ? &nbsp;My guess is that the answer is no as there may be differences in the objects and even the schema as the newer versions are released, and this MSDN page seems to support that (see Limitations on Restoring System DBs at <a href="http://msdn.microsoft.com/en-us/library/ms190190.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190190.aspx</a>&nbsp;) , but an associate is telling me that it is okay. &nbsp;What are the thoughts are consensus on this ? &nbsp;TIA ...
</div>
</div>


When doing a side-by-side upgrade or migration of MS SQL Server 2005 to MS SQL Server 2012 can one or should one backup the MS SQL Server 2005 System DBs and do a restore of those to the clean MS SQL Server 2012 installation to facilitate the migration process ?  My guess is that the answer is no as there may be differences in the objects and even the schema as the newer versions are released, and this MSDN page seems to support that (see Limitations on Restoring System DBs at http://msdn.microsoft.com/en-us/library/ms190190.aspx ) , but an associate is telling me that it is okay.  What are the thoughts are consensus on this ?  TIA ...

MS SQL Server 2005 to MS SQL Server 2012 Upgrade - System DBs

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.