I need any help with moving all open Requests/Problems/Changes to a new database. Recently created a new Servicedesk system and database, that I would like to roll out in place of our current older version. I was wondering if there is any quick ways to move this data over, I only want to pull data from a month back and if further, only open Requests/Problems/Changes. Is there a way other than doing this through a SQL Server Management Software ?
I was particularly wondering if I were to go into each ticket and reply by email through the system and change the address to the new service desk system, would that successfully import these requests ? or would this cause database corruption, or flat out not work. If anyone else has gone through something like this, I would really appreciate any insight.
Thanks.