Link to home
Start Free TrialLog in
Avatar of SmashAndGrab
SmashAndGrab

asked on

Migrating SSIS from 2005 - 2012?

Hi,

I am in the process of migrating a SQL server 2005 to a SQL server 2012.     On the 2005 server,  SSIS packages are used to upload CSV data into various databases.  These SSIS packages are created in Visual studio 2005.

My questions are around the versions of software I require on the new server:

1.  Will the new SQL 2012 server require an install of visual studio? if so, which version?  It would only be used for SSIS development - would an express version be suitable?
2. Are there any migrating tools to help?
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

>> 1.  Will the new SQL 2012 server require an install of visual studio? if so, which version?  It would only be used for SSIS development - would an express version be suitable?

In SQL Server 2012, BIDS will be called as SQL Server Data Tools with a newer version of Visual Studio.
If you would like to do just SSIS Development, then you can install SQL Server Data Tools and then do your development by connecting to your SQL Server 2005 Server or any other 2012 server as well. No need to install Database Engine Services and hence Express edition not required.

>> 2. Are there any migrating tools to help?

Just open up your existing packages in SSDT and it will guide you through the process while saving it..
https://docs.microsoft.com/en-us/sql/integration-services/install-windows/upgrade-integration-services-packages-using-the-ssis-package-upgrade-wizard?view=sql-server-2017
ASKER CERTIFIED SOLUTION
Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial