Post reply

MSDE - Migrating Triggers and DTS packages from one server to another

  • January 13, 2009 at 8:22 am

    #133593

    I have to move an MSDE database from one server to another. I think the triggers will be intact when I make a backup and restore on the new server being used for MSDE, but I don't think the DTS packages will follow.

    Is there a SQL command I can use to script out the DTS packages and Triggers and then run on the new server to re-create them? Sure miss the graphical interface!

    Thank you.

    Rog

  • January 13, 2009 at 8:37 am

    #925938

    You can use any EM to do this and connect to an MSDE instance. The triggers are stored in the database, so a backup and restore will move those.

    I didn't think DTS packages could exist in MSDE. If they are, then you need to "open" them and save them on the new server or save them a structured storage files in the file system and copy them over. They can be run from the filesystem or you can load them back into msdb on the new server.

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

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