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 |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-09-26 : 09:46:29
|
| Hi,we are moving our jobs from test to production.whar are the things to be moved?DTS,database,Jobs or other things are there??if we want to move jobs , how can we do that?? |
|
|
beyonder422
Posting Yak Master
124 Posts |
Posted - 2005-09-26 : 09:48:56
|
| You can script that. right click job, "All tasks", "generate sql script".run the script on your target server. but make sure all the required objects are there. |
 |
|
|
priyaram
Yak Posting Veteran
82 Posts |
Posted - 2005-09-26 : 09:55:08
|
| Only we need to move jobs,database and DTS.R other things also there??since i am involved for the first time , i am asking |
|
|
|
beyonder422
Posting Yak Master
124 Posts |
Posted - 2005-09-26 : 10:20:06
|
| To do the database, you can detach the db and re-attach it.It will bring the db down, but that's the fastest most complete way I do it. If you have to stay up, there are other ways. (Export all objects, with data - it's convoluted)Jobs, as mentioned, script them.DTS, I'm not very familiar with doing those in bulk, other than going in and doing a "Save As" to the target server, for each one. I would have to assume there is a better way, but I've never had to do it in bulk. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-09-26 : 11:28:25
|
| Depending on what kind of authetication you have, you might also need to have the same users on the Production Server, with the same settings.Igor. |
|
|
|
|
|
|
|
|
Moving from test to production