May I ask for your new coresight server, are all the displays using the same PI/AF servers or not ?
All displays will use the same PI/AF servers.
If all the displays will use the same PI/AF Servers, you can simply move the Coresight database from one SQL machine to another as all Coresight displays are stored in the SQL database. Please try following steps:
1. Run go.bat file to install Coresight database on new SQL server
2. Backup the old Coresight database
3. Restore the old database to new SQL server
4. Configure Coresight to use the new database.