InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 19:54:53 GMT20http://www.sqlservercentral.com/Forums/Topic1423419-2799-1.aspxStupid question. Can I install SQL2012 upgrade advisor on Windows 2003 server to check for the SSIS packages compatibility?Wed, 27 Feb 2013 14:46:05 GMTSQL_Surferhttp://www.sqlservercentral.com/Forums/Topic1423419-2799-1.aspxMay I suggest as a first step in your upgrade task using the UPGRADE ADVISOR[url]http://msdn.microsoft.com/en-us/library/ms144256.aspx[/url]2. If you have "extra" hardware available purchase a copy of the DEVELOPER EDITION of SQL Server 2012 (available on Amazon.com for about $50 U.S. dollars). install it, and create a copy of the current DB and install same using the DEVELOPER EDITION as your 2012 Server. 3. Make the changes recommended by the run of the UPGRADE ADVISOR, [b]RECORED / SAVE EVERY CHANGE[/B].4. Then test the revised DB using a sample of typical daily activity ... updates/deletes/report/etc.etc. Make the necessary alteration(s) [b]RECORED / SAVE EVERY CHANGE[/B].Sun, 24 Feb 2013 11:15:01 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic1423419-2799-1.aspxI will be migrating my 2005 enterprise SQL to 2012 enterprise. Anything I need to consider? 2005 has some replication job, multiserver jobs and about 500 ssis packages. Any advice would be sincerely appreciated.Sun, 24 Feb 2013 08:55:54 GMTSQL_Surfer