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 |