December 17, 2008 at 2:39 pm
Hi
Can anyone please tell me , if i have the scripts of all jobs in sql server 2000 then how they can be transferred to sql server 2005.
Or please let me know some other way out to perform the activity.
December 17, 2008 at 2:50 pm
Log into a SQL 2005 server....
Open SQL Server Management Studio....
Direct the login to the SQL 2000 server...
Navigate to your SQL jobs you want to migrate...
Right click the job and select "Script as Crate to..."
Now if you have DTS packages, you will have to either convert them to an SSIS package or import as a "Legacy" DTS package. I highly recomend the SSIS conversion.
This works best on jobs that are T-SQL based. Anything with DTS packages will require additional conversion as I mentioned above.
December 17, 2008 at 2:53 pm
You can also go into SQL Server Agent -> Jobs
Select All (ctrl-A), right-click, "Script Jobs as" -> CREATE TO .... a new Query window (or File)
Then you run the script on the SQL Server 2005 server
December 17, 2008 at 3:49 pm
Jobs are fairly portable its the DTS packages if you have any that give the real headaches
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply