SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:56 PM
| ||||
| ||||
 SQL 7.0 to SQL2K Migration including Jobs and DTS packages I have a SQl Server 7.0 database that needs to be migrated to another server and to SQL2K version. For absolute simplictiy is this possible 1. Upgrade existing SQL7.0 database in place to SQL2K 2. Backup all databases including System DBs and restore to new Server Will backup/restore of the master, msdb, tempdb port over all my jobs and DTS packages to the new server. My main concern is getting all the jobs and DTS packages over to the new server and from SQl 7 to SQL2k Thanks Scott      |
|
02-28-2008, 05:57 PM
| ||||
| ||||
| Re: SQL 7.0 to SQL2K Migration including Jobs and DTS packages "Scott Boucher" <sboucher@state.pa.us> wrote in message news:e5445725.0309161718.599fe1ee@posting.google.c om... > I have a SQl Server 7.0 database that needs to be migrated to another > server and to SQL2K version. > > For absolute simplictiy is this possible > > 1. Upgrade existing SQL7.0 database in place to SQL2K > 2. Backup all databases including System DBs and restore to new > Server > > Will backup/restore of the master, msdb, tempdb port over all my jobs > and DTS packages to the new server. My main concern is getting all > the jobs and DTS packages over to the new server and from SQl 7 to > SQL2k > > Thanks > > Scott Your plan should work fine. In fact, the upgrade wizard supports upgrading directly to a different physical server, but personally I'd play it safe and do it in two steps. The upgrade should also handle your DTS packages OK. There's more information about DTS in "SQL Server 2000 and SQL Server version 7.0" in BOL 2000. Another option is to backup all your user databases on SQL7, then restore the backups on SQL2000. Then you can use the DTS Copy Jobs and Copy Logins tasks to bring those over, and the packages themselves like this: http://www.sqldts.com/default.aspx?t...&i=204&p=1&a=0 That might be a safer option if you don't have spare hardware to test the upgrade on, or if your upgrade window is limited - the SQL7 box is always there if something goes wrong. Simon |
Linear Mode
