Migrate 9.3 scripts to another 9.3 installation

[winningham_2]

I have a departmental JSS that I need to migrate/integrate with a larger unit's JSS. I was wondering if I can use the API or perhaps a method you have found to migrate the JSS-housed scripts?

Looking through the API I see that a test returns some metadata regarding the script but not the actual script.

Any thoughts?

[dwandro92]

The easiest way would probably be to use a MySQL database viewer/administrator program on both clients. On Windows I use HeidiSQL, and Mac has a similar utility called jHeidi, but use whatever works best for you. Simply do the following (on a weekend or at a time when machines aren't running policies) :

1. Backup/export the entire JSS database on the destination machine
2. Export the desired script data from the the "scripts" table of the JSS database on the source machine
3. Open the exported file in a text editor and modify important values (ID/key, category, etc.)
4. Import the edited data on the destination machine
5. If problems arise, import the destination machine's backup/export