I would not suggest doing it, I may be wrong but I don't see any way of simply copying a maintenance plan...even if you could you look at challenges around...

Adam, I don't quite get...

Have to agree with Paul.

ETL for a whole db doesnt really make sense.

Backup and restore would be a good idea.

Check out Brent Ozar's blog...

http://www.brentozar.com/sql/sql-interview-questions/

Have you tried importing the DTSX packages from one SSIS instance to another?

Ensure you add encryption on them should there be stored passwords etc in them.

Hi Hugo, yes, looking at the last where statement, it was easy to determine the answer.

But, look at the wrong answer rate - 19 so far.

This question was purely to...

Yes, it's called a backup.

Vijay, how about trying a script posting us your effort, and then we'll see where we can assist.

There was a long thread about people just asking for scripts, instead of...

start of with creating a table with an ID column, and a column with your server/db names.

use the row ID's to get the server names in each loop, with a...

Even though your jobs reflect the new name, did you change the run as account as well?

Fully agree.

Bad formatting is almost as ugly as bad coding. When handing over your code/work you should

feel confident that any developer can look at it and be able...

Read up at

http://msdn.microsoft.com/en-us/library/ms144275.aspx

http://www.sqlservercentral.com/Forums/FindPost937448.aspx

please don't post duplicates.

They can sue you, and the company who paid/hired you to steal the information, and prevent the "thieves" from using the information.

They will also ensure you never work at any...

This might not necessarily be the easiest or most correct, but my own thoughts...

script out the "Drop and create" whole database structure, but before creating, change the data type!