Geoff, I am doing the exact same thing at the moment. I think that there should be an easier way than this, but this is what I have so far
select distinct 'query script',name,'f=raw outputfile=',name from scripts > scripts.scr This gives you a text file of the format below for every script that you have (you will have to delete a space between outputfile and scriptname) query script <scriptname> f=raw outputfile=<scriptname> You can then run this file as a macro/script to output all of your scripts in raw format to an individual text file with the respective script name as the filename. You can then copy these files to your new server. Using find and replace or text editing tools you can slightly modify your generated script from above to the format def script <scriptname> file=<filename> Then run this script and it will generate all your scripts on your new server. I have to add that using the select to generate the original script is not my own work, I stole it from a previous posting enquiring how to script a number of move datas, but it is neat. Credit the original poster (IIRC WP) If I find a better way, I'll let you know, likewise visa versa. Leigh -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 25 January 2007 16:40 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] exporting scripts I think this has been asked before but I can't seem to find anything so hopefully my asking again won't be a big deal. I am trying to figure out if there is a way to export all of my scripts from one server so I can import them to another. I have tried to manually create these scripts but sometimes the 5.3 GUI chokes and won't let me, even though I have copied them exactly. If anyone has any thoughts on the easiest way to accomplish this I would appreciate it. This second server is for testing so I'm not looking to make anything permanent. Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED]
