locked
Migrate SQL server 2005 cluster to SQL Server 2012 cluster RRS feed

  • Question

  • Hello,

    I am planning to migrate DTS packages from SQL server 2005 cluster to SQL Server 2012 cluster.please anyone tell me what are the prerequiste and what are the steps.

    please provide any documentation.

    Thank u

    regards

    chandra




    • Edited by RAJ927 Tuesday, March 8, 2016 3:12 PM
    Tuesday, March 8, 2016 3:05 PM

Answers

  • Yes Shanky That is correct.but in my environment DTS packages  in SQL Server 2005 because SQL Server 2005 Supports DTS packages also.please tell me the what is the procedure to Migrate DTS packages in sql server 2005 to 2012

    thank u


    First convert those to SSIS packages. Its all written in article I shared please take time and read it

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    • Marked as answer by RAJ927 Tuesday, March 8, 2016 6:48 PM
    • Unmarked as answer by RAJ927 Tuesday, March 8, 2016 6:48 PM
    • Marked as answer by RAJ927 Wednesday, March 9, 2016 12:05 PM
    Tuesday, March 8, 2016 6:03 PM

All replies

  • I hope when you have 2005 database you have SSIS packages not DTS packages, DTS were when you had SQL Server 2000.

    Anyways please see Migrate SQL Server SSIS packages


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    Tuesday, March 8, 2016 3:24 PM
  • Yes Shanky That is correct.but in my environment DTS packages  in SQL Server 2005 because SQL Server 2005 Supports DTS packages also.please tell me the what is the procedure to Migrate DTS packages in sql server 2005 to 2012

    thank u

    Tuesday, March 8, 2016 3:53 PM
  • Yes Shanky That is correct.but in my environment DTS packages  in SQL Server 2005 because SQL Server 2005 Supports DTS packages also.please tell me the what is the procedure to Migrate DTS packages in sql server 2005 to 2012

    thank u


    First convert those to SSIS packages. Its all written in article I shared please take time and read it

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP

    • Marked as answer by RAJ927 Tuesday, March 8, 2016 6:48 PM
    • Unmarked as answer by RAJ927 Tuesday, March 8, 2016 6:48 PM
    • Marked as answer by RAJ927 Wednesday, March 9, 2016 12:05 PM
    Tuesday, March 8, 2016 6:03 PM
  • ok thank u
    • Marked as answer by RAJ927 Wednesday, March 9, 2016 11:49 AM
    • Unmarked as answer by RAJ927 Wednesday, March 9, 2016 12:00 PM
    Tuesday, March 8, 2016 6:53 PM