You are here: CORE PC Support Home > CORE PC V2 Client Server Configuration > Moving CORE PC data to a dedicated SQL Server

Moving CORE PC data to a dedicated SQL Server

Moving the CORE PC database from a workstation to a dedicated SQL Server:

1. Find the data

If more than one workstation is being used, the workstation that is currently acting as the CORE PC database server needs to be identified. On any of the workstations run CORE PC and observe the "splash" screen, look for the line starting with the word "Server: " which will give the name of the workstation currently acting as the CORE PC database server . If it reads "Server: (local)" the data is hosted on this machine.

2. Copy the database files to the dedicated server

Make sure that all users are out of CORE PC.

Stop the SQL Server service on the machine hosting the database. You can do this throught the services management screen or by clicking Start > Run, and typing "sqlmangr".

Copy the two SQL Server data files

"C:\Program Files\COREIMS\COREPC2\Database\corepc_data.mdf"
and
"C:\Program Files\COREIMS\COREPC2\Database\corepc_log.ldf"

to your chosen data folder on the Windows Server hosting the SQL Server.

3. Configure the SQL Server for use with CORE PC

See configuring a dedicated SQL Server

4. Test your dedicated SQL Server configuration by connecting a CORE PC workstation to the server

See Connecting CORE PC client workstations to the SQL Server

5. De-activate the original CORE PC Database on the workstation

To prevent confusion de-activate the CORE PC Database on the original workstation. Stop the SQL Server service on the original workstation (Start > Run, "sqlmangr"), re-name the folder "C:\Program Files\COREIMS\COREPC2\Database" to "C:\Program Files\COREIMS\COREPC2\Database-old".


 

For additional Support Information, please call CORE PC Support on 01788 297130, or email support@coreims.co.uk