upgrade massive DTSX from SQL2008 R2 to SQL 2012 SP1

24/03/2013

אין תגובות

Hi,

Lesson learned from upgrade more than 2000 packages located on a file system.

1.open SSDT

2. convert to package deployment model

3. add existing packages- No more than 100, it will stuck otherwise.

4. copy all necessary configuration files.

5. right click on the package folder click upgrade.

6. save report for QA needs.

Done

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *