You could create the new custom property and them use a quick SQL update to copy the data across.
The easiest way would be to rename it through SQL Server Management Studio. Of course, you could use CPE to create the new one, select the entire column from the old one, then copy and paste the entire column to the new property.
you could use CPE to create the new one, select the entire column from the old one, then copy and paste the entire column to the new property.
Thanks for everyone's input.
vhcato, I thought of doing as you suggested but we wanted to keep the same CP name. We would still need to deal with reordering the CPnames for ease of use in CPE.
So, here is how we ended up doing it.
1. Login to the SQL machine
2. Open "Enterprise Manager"
3. Expand to the following folder in the left hand column
a. Microsoft SQL Servers > SQL Server Group > local (Windows NT) > Databases > NetPerfMon > Tables
4. Right Click on the Nodes table in the Right hand column
5. Select "Design Table"
6. Left click on the Gray box to the far left of the row you wish to move (Sorted by column name)
7. Rename Custom Property
To reorder Custom Properties - Left click and hold to drag the row to any desired location
8. Make any other moves necessary following steps 6 and 7 until complete.
9. When prompted to "Save Changes" Click "Yes"
a. The database does not need to be stopped or halted during these changes
10. Close "Enterprise Manager"
11. Logoff of the SQL Machine
12. Update Report Schemas.
Update Report Schemas
1. Login to the Orion machine running Custom Property Editor
2. Open Custom Property Editor
3. Right Click in the Gray area to the right of the icon menu bar
4. Choose Customize from To drop down
5. Click on the Commands Tab
6. Scroll to the bottom of the list on the right hand side of the window
7. Click and Drag the "Update Report Schemas" icon from the window to the same area you right clicked on in Step 3
*8. Double click on Update Report Schemas to update the reports with the new schemas from any changes you have made to the custom property editor or database
*Any reports that reference the custom properties that you have changed will need to be corrected. The original custom properties you created will have been repleced with * in any Report Writer reports.
a very old post here, but do you think you need to stop NPM when doing this?
also, do you think the alert trigger confoigurations that use custom properties will still work? All i was going to do was drag the columns about, NOT rename any
I just want to get them into the right order
If you're simply re-arranging the columns, you should not need to stop NPM, and your CP-dependent alerts should work just fine.
excellent, thanks for the reply on such an old thread!