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
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 firstname.lastname@example.org