Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2009-01-08 : 02:55:20
|
| Dear Experts,i've migrated several databases from sql server 2000 servers to sql server 2005 servers. which are different servers. i've sp_revlogin to script all the users to create there in the new server. but i dont know how to transfer all the jobs. please provide me guidance in this regard. Note : 1) i've scripted the jobs, but while running those scripts in the new server, i'm getting error.2) backup and restoring the MSDB database will get all the jobs from old server to the new server?thank you very muchArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-08 : 09:20:10
|
| Use Transfer Job Task in SSIS to achieve it. |
 |
|
|
|
|
|
How to migrate Jobs