Multiple SQL servers Consolidation to one Single SQL Cluster RRS feed

  • Question

  • Here is my situation:

    I have a project which includes different 71 databases on around 20 different SQL servers with different versions (2000,2005,2008,2008 R2...) and collations. the mission is to consolidate all the Servers into one SQL Cluster. Now i would like to know what would be a best practice action plan to tackle the project using the SSIS packages, what would be possible scripts i would have to use before starting my work.

    I would appreciate any help on this. 

    Teddy Bejjani - BI Specialist @ Netways

    Monday, May 28, 2012 11:31 AM


All replies