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

Migrate SSIS from 2005 2012 Expand / Collapse
Author
Message
Posted Friday, November 15, 2013 7:30 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 328, Visits: 854
I have about 600 packages saved in MSDB 2005 SQL server. I have new box where I installed SQL 2012. What is the fast and quicker way to migrate packages from 2005 to 2012 sever. Packages are pretty basic.
In 2012, I can save it in file system instead of MSDB if that makes it faster for migration process. Any suggestion would be greatly appreciated.
Post #1514883
Posted Friday, November 15, 2013 8:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:07 PM
Points: 16, Visits: 153
You should be able to open SQL Data tools on from the 2012 box and open the project and upgrade all packages. When we did this we wanted to keep the production packages "2008" running. So I used the file system made a copy then upgraded the copied version. Once this was done we moved the packages into the 2012 deployment model. Then pointed the production to the upgraded packages. Do not know if this helps.
Post #1514887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse