November 29, 2012 at 9:32 am
Hello,
What is the best way for moving packages from one server to another in SQL 2012 environment?
The packages were deployed on dev box using the new feature in SSIS 2012 (Project Deployment Model). On dev box I will have about 12 projects and 150 packages.
Is there any tool to move them in bulk?
Thank you!
November 29, 2012 at 2:52 pm
You can deploy projects with Powershell:
SSIS and PowerShell in SQL Server 2012
(first example, but it talks about deployment from filesystem to server. I think server to server should be possible too.)
Using stored procedures should work as well:
Deploy and Execute SSIS Packages using Stored Procedures
I'm not sure you can do it in one step. I think you'll have to extract the packages, save them in a location and then read the bytestream back in at the destination server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply