Post reply

COPY JOBS FROM SQL SERVER 7.0 TO SQL SERVER 2000

  • October 20, 2008 at 1:48 pm

    #214267

    Hi All

    Can anyone tell me how to copy the jobs from sql server 7.0 to sql server 2000 ( besides creating scripts ).

    Thanks

  • October 20, 2008 at 4:44 pm

    #887360

    You could try the Transfer Jobs Task in DTS. I've only used it once, so I can't offer much advice about it. I've mostly used scripting.

    Greg

  • November 18, 2008 at 4:04 am

    #899764

    these are the examples ..

    XP_CMDSHELL copy '"\\192.168.0.1\c$\Folder1\File1.txt" "C:\TMP\" /user:User1 PASSWORD'

    EXEC master..xp_cmdshell 'copy \\Dell1\test\query.sql c:\dell'

    EXEC master..xp_cmdshell 'copy "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\san" "C:\TestLogshipping"'

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

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