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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-08 : 07:26:19
|
| María writes "Using CDW for migrating from a SQL Server 7.0 database to a SQL Server 2000 database, there were jobs which had not been transfered.Do you know about this?Sorry by my bad english!!!MP" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-08 : 12:18:39
|
| Jobs do not get transferred with the CDW. You can generate the scripts for the jobs by right clicking on them and then running the script in 2000. Jobs are stored in the msdb database and not in the user database.Tara |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2003-09-09 : 01:45:30
|
| Tara, Just curious...Can we migrate msdb also? To get all agent related activities?---------------------------Sandesh - The Messanger |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 11:54:28
|
| Yes you can. But I would not use the wizard to do it. I would use the BACKUP/RESTORE commands in Query Analyzer.Tara |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2003-09-09 : 16:11:39
|
| Actually system databases are not compatible between the different versions of SQL Server. If you restore MSDB backup from SQL7 on the new SQL2k server your SQLAgent will not start. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 17:03:24
|
| Oh yeah, forgot the question was about upgrading from one version to the next. My answer was related to copying a database to the same version.Tara |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2003-09-09 : 21:46:12
|
| Then what is the solution to migrate SQL7 jobs to SQL2K?---------------------------Sandesh - The Messanger |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2003-09-09 : 22:26:32
|
| Use Enterprise Manager to generate scripts for each job. Execute the scripts on the SQL2k box. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-10 : 11:47:02
|
| Didn't I mention that in my first post?Tara |
|
|
|
|
|
|
Copy Database Wizard - Jobs