Post reply

DTS and Jobs

  • July 27, 2006 at 2:18 am

    #94167

    Hi,

        Is there a way to create an installer to deploy a database, dts and scheduled jobs to a production server.

     

    Thanks

  • August 2, 2006 at 2:11 am

    #652752

    Depending on whether you just want the empty database or the data as well, you can script out the creation or restore of the database.  Do the same for the jobs. You can save the DTS packages as Visual Basic files, and if you know some VB, you can write some code to recreate these on the production server.

    John

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply