SQL Jobs

cgautreaux

I am migrating from 2000 to 2005 using the ole detach attach method. There are 47 databases. Is there an easy way to use your tools to sync the sql jobs?
:?:

David Atkinson

Thanks for your request. I've logged this in the system. Jobs aren't considered to be schema objects so they're out of SQL Compare's scope, but as all suggestions, we'll consider them on their own merits if we get enough interest.

Kind regards,

David Atkinson
Red Gate Software

cgautreaux

Good enough.

Thanks for the reply.

keymoo

cgautreaux wrote:

I am migrating from 2000 to 2005 using the ole detach attach method. There are 47 databases. Is there an easy way to use your tools to sync the sql jobs?
:?:

You could script them out easily if you don't have many. If you have lots then use some kind of automation with SMO.