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 |
|
jacksja
Starting Member
4 Posts |
 Posted - 2010-04-20 : 11:58:53
|
| Hi sql server gurus,I am new to sql server administration. Is there a way to export the maintenance plans from sql 2000 to 2005. I am in the process of upgrading the database for one of our critical apps, and the vendor documentation requires that the database be unistalled and 2005 installed with the datafiles reattached.I noticed that I can script the jobs by right clicking and selecting scripting and specifing a directory. I'm hoping that I can run these scripts in the newly created master database and have all my maintenance imported in 2005 this way.Does anyone know whether this will work, and if not suggest a way in which this can be done.Thank you,Jack |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jacksja
Starting Member
4 Posts |
Posted - 2010-04-20 : 13:55:12
|
| Tara,I appreciate your reply,James |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-04-24 : 21:11:00
|
| Tara - that's not quite true. You can export/import maintenance plans in 2005/2008 - but it is a bit tricky. Create a new SSIS Integration Services project in BIDS. In the solution explorer, add an existing package - select your SQL Server instance and the maintenance plan.Once imported, change the connection information to the new server. Then, change the databases and file locations in the defined tasks. Note: do not change anything else, as that could invalidate the maintenance plan and it won't work. When finished, select File and copy the package as a new package and save to the new server under the maintenance plan folder.To the original poster - you should be able to create your jobs from 2000 to 2005 with no problems. The 2000 maintenance plans will not actually be copied, but the command in the job will - and that will also work. |
|
|
|
manoj.ks
Starting Member
1 Post |
|
|
|
|
|
|
|
Export maintenance Plans