Best way to move records to one table to another

[tessao]

Hi all! 

I'm fairly new to SN, and have been given the task to take our current production Incident table and transfer the old records to a new Help Desk table.   I've found multiple articles on how to go about this, but would like to know best practice.

My other question in relation to this, is that we want to keep the current incidents the same so prefix incxxxxx.  But start our new prefix, HDxxx based off of the current incident number.  So if we're on INC00002, I want HD00003 to be the next record.

Any tips or advice would be greatly appreciated!

Thanks!

[SanjivMeher]

If the Help Desk table extends the same task table, all you need to do is change the Task type field in the incidents records to HelpDesk.

\And yes you can have a different prefix.

Go to number maintenance and click on Show counter and change the counter to your latest value for Help Desk table.

[tessao]

Thanks Sanjiv for the number maintenance tip, exactly what I was looking for! 

Question for you though, so I have seen this "Task Type" field referenced in a few forums, but I want to confirm this so I don't blow up our production instance lol, so I go to Tables --> Incidents --> Task Type and just change what exactly?  The table or type, this is where I'm getting a bit confused/ paranoid.  

Currently the Incident Task Type Table is set to Task, and Type to System Class Name.  I believe you're saying I need to change the table to Help Desk?  

Thanks again for your help!!

[SanjivMeher · Accepted solution]

No. Open the incident table in List View. Add Task Type to your List view. And then mass update all the records you want to update by selecting the Helpdesk as task type.

If you have too many records, use a background script to update this field. Try doing it on Non-PROD, before doing on Production