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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-03-16 : 11:50:22
|
| Dear All,1.I have nearly 200 Jobs which i need to copy from SQL server 2000 to SQL server 2005 what is the easy step ?2.Also i need to migrate all the logins from one instance to another instance what is the easy process ?Thanks,Gangadhar |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-03-16 : 13:33:23
|
| script out all the jobs and compile them on the new server.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Job migration from 2000 to SQL server 2005