Friday, February 24, 2012

Help with migrating jobs from SQL 2000 to SQL 2005

We need to migrate 500 jobs from SQL 2000 to SQL 2005 but we are getting
error hat one of the fields can’t be NULL. The field in question is OWNER_SID.
The question is how do we get the field from SQL 2000 ?
What we have try using Business Intelligent Studio to copy the jobs with out
success.
Jarek
You said that scripting out the jobs and the running them on SS2005 does
not work? In that case I think you are going to re-create them manually
"Jarek Gal" <JarekGal@.discussions.microsoft.com> wrote in message
news:DE8B79F8-FD96-4EDB-8BFE-742EC5379305@.microsoft.com...
> We need to migrate 500 jobs from SQL 2000 to SQL 2005 but we are getting
> error hat one of the fields cant be NULL. The field in question is
> OWNER_SID.
> The question is how do we get the field from SQL 2000 ?
> What we have try using Business Intelligent Studio to copy the jobs with
> out
> success.
>
|||Uri
Yes we try that and it's aking for OWNER_SID which it looks like was not in
the script.
Thanks
"Uri Dimant" wrote:

> Jarek
> You said that scripting out the jobs and the running them on SS2005 does
> not work? In that case I think you are going to re-create them manually
>
>
>
> "Jarek Gal" <JarekGal@.discussions.microsoft.com> wrote in message
> news:DE8B79F8-FD96-4EDB-8BFE-742EC5379305@.microsoft.com...
>
>

No comments:

Post a Comment