Old SSIS in SQL Server 2012 -
we in process of migrating our sql server 2005 2012 version.
there's significant number of ssis (developedn in vs 2005) running on server.
will ok re-deploy these packages on new sql instance?
or have go through visual studio upgrade process each?
any comments, advice appreciated.
thanks in advance.
you're looking @ upgrade, variety of reasons.
in 2005, packages have been stored in msdb.dbo.sysdtspackages90 2008 forward, table renamed msdb.dbo.sysssispackages
even if deploy them sysssispackages , kept 2005 integration services service installed, don't think 2005 dtexec work 2008 version of stored procs in msdb relative ssis work. procs should backwards compatible msdb ssis "stuff" in 2012 poured of attention 2012 ssisdb catalog , clr methods there.
depending on connection managers, sql server ole db connection strings changed sqlncli01 sqlncli1.0 (approximate)
the internals of how data flows works has changed. mechanism signaling end of rows changed between 2005 , 2008 if have custom components, have reworked.
when convert 2005 2012, can migrate project deployment model or package deployment model. seems looking minimum of change, stick package deployment model. project deployment model entail forgoing configurations in lieu of fancy new parameter methodology.
Comments
Post a Comment