Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrating from 2005 to 2012 Expand / Collapse
Author
Message
Posted Sunday, February 24, 2013 8:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 16, 2014 12:56 PM
Points: 332, Visits: 868
I 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.
Post #1423419
Posted Sunday, February 24, 2013 11:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
May I suggest as a first step in your upgrade task using the UPGRADE ADVISOR

http://msdn.microsoft.com/en-us/library/ms144256.aspx

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, RECORED / SAVE EVERY CHANGE.
4. Then test the revised DB using a sample of typical daily activity ... updates/deletes/report/etc.etc. Make the necessary alteration(s) RECORED / SAVE EVERY CHANGE.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1423433
Posted Wednesday, February 27, 2013 2:46 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 16, 2014 12:56 PM
Points: 332, Visits: 868
Stupid question. Can I install SQL2012 upgrade advisor on Windows 2003 server to check for the SSIS packages compatibility?
Post #1424763
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse