SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Want to deploy msdb pkgs from one server to another server msdb


Want to deploy msdb pkgs from one server to another server msdb

Author
Message
prudhivi9
prudhivi9
SSC-Enthusiastic
SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)

Group: General Forum Members
Points: 100 Visits: 47
Hi All,

Actually we are working with two servers,
my requirement is like this,
i want to copy packages from server A msdb to Server B msdb.
Am having many number of packages in my server A msdb.
so i want to copy all the packages at a time.
Can any body gimme an idea to do it.

Appriciate the response.

Thanks,
Quest.
rhythmk
rhythmk
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1658 Visits: 1099
prudhivi9 (7/4/2012)
Hi All,

Actually we are working with two servers,
my requirement is like this,
i want to copy packages from server A msdb to Server B msdb.
Am having many number of packages in my server A msdb.
so i want to copy all the packages at a time.
Can any body gimme an idea to do it.

Appriciate the response.

Thanks,
Quest.


Please have a look on below link.

http://www.sqlservercentral.com/Forums/Topic530477-1329-1.aspx


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
:-)
prudhivi9
prudhivi9
SSC-Enthusiastic
SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)SSC-Enthusiastic (100 reputation)

Group: General Forum Members
Points: 100 Visits: 47
Hi,
I jst followed the link wh u hav specified there,
but one thing is like how to create a batch file for all the packages, can i get any syntax for that.

Thanks for rply
quest.
rhythmk
rhythmk
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1658 Visits: 1099
prudhivi9 (7/4/2012)
Hi,
I jst followed the link wh u hav specified there,
but one thing is like how to create a batch file for all the packages, can i get any syntax for that.

Thanks for rply
quest.


Below is for moving one packages.

dtutil /FILE <name>.dtsx /DESTSERVER SQLServer /COPY SQL;<name>

OR

dtutil /MOVE SQL;destPackage /SQL srcPackage /SOURCEUSER srcUserName /SOURCEPASSWORD $Hj45jhd@X /DESTUSER destUserName /DESTPASSWORD !38dsFH@v

Likewise you need to put all in a for loop.

However I got one more solution for you hope that also work.

1. Open MS Visual Studio, and create a new Integration Services project if you already don’t have one.

2. In the solution Explorer under SSIS packages - right click on the folder – Add existing packages (add original packages)

3. Right click on the project – Property. Specify the output path for your build. Click on Deployment utility and set “Create DepoloymentUtility” to true. Specify the output Path. Click OK.

4. Right click on the project – Build. The packages with a deployment utility should be under the directory specified in step 3.

5.Copy the entire deployment folder and paste it to the server you want to move the packages to.

6. Log in to the server and navigate to the directory made in step 5. Double click on the xxx.SSISDeploymentManifest file to initiate the deployment wizard.

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
:-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search