none
Scripting Integration Services Catalogs RRS feed

  • Question

  • Hi All,

    I am using SS 2012 , So I wanna move   Integration Services Catalogs and SSISDB database from DEV server to QA server?

    How can I script it out? SO I can run the script on QA machine

    Thanks

    Gok

    Monday, December 29, 2014 7:36 PM

Answers

All replies

  • You should instead create a deployment model http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012-part-1-of-2/ and use to push packages to a relevant environment.

    Thing is, doing what you envisioned is not how SSIS was designed to function.

    If you are new to SSIS I suggest you buy a book or get at least some basic training using other means.

     

    Arthur

    MyBlog


    Twitter

    Monday, December 29, 2014 8:29 PM
    Moderator
  • Thanks for your answer Arthur but I think I couldnt explain what I wanna do

    Also I have 9 years exp. in MS BI

    I dont want to deploy any SSIS  packages to QA server instead I want to create  script for the SSISDB and Catalog

    so I think I have to be able to restore SSISDB from DEV and create SSIS Catalog on QA server then I will be OK.

    Monday, December 29, 2014 8:47 PM
  • Thanks for your answer Arthur but I think I couldnt explain what I wanna do

    Also I have 9 years exp. in MS BI

    I dont want to deploy any SSIS  packages to QA server instead I want to create  script for the SSISDB and Catalog

    so I think I have to be able to restore SSISDB from DEV and create SSIS Catalog on QA server then I will be OK.

    SSIS Catalog and Folder structure should be done manually.

    To copy ENV Variables, you may refer SQL query provided below:

    http://mikedavissql.com/2012/05/02/ssis-2012-copy-or-duplicate-environments/


    -Vaibhav Chaudhari

    Tuesday, December 30, 2014 6:12 AM
  • Thanks for your answer Arthur but I think I couldnt explain what I wanna do

    Also I have 9 years exp. in MS BI

    I dont want to deploy any SSIS  packages to QA server instead I want to create  script for the SSISDB and Catalog

    so I think I have to be able to restore SSISDB from DEV and create SSIS Catalog on QA server then I will be OK.

    If you want is to backup restore SSIDB see this

    http://blogs.msdn.com/b/mattm/archive/2012/03/23/ssis-catalog-backup-and-restore.aspx


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page


    • Edited by Visakh16MVP Tuesday, December 30, 2014 6:47 AM
    • Proposed as answer by BI_Support Tuesday, December 30, 2014 11:00 AM
    • Unproposed as answer by Gok Sky Tuesday, December 30, 2014 1:30 PM
    • Marked as answer by Gok Sky Tuesday, December 30, 2014 1:38 PM
    Tuesday, December 30, 2014 6:46 AM