Important! Before starting this process please take a full SQL backup of the DiaMed database and store it in a secure location.
The easiest way to move the DiaMed database from one server to another is simply to detach the catalog files from the current server and move it to the new server. The steps for doing this are outlined below.
Step 1 - Remove DiaMedApp User
a) Run SQL Server Management Studio
b) Connect to the current server using SA or an Administrator login
c) Once connected, expand the server
d) Expand the Security\Users folder
e) Right click on DiaMedApp and click Delete
f) Click Yes to delete the Schema and remove the user.
Step 2 - Detaching DiaMed from the Current Server
a) Run SQL Server Management Studio
b) Connect to the current server using SA or an administrator login.
c) Once connected, expand the server.
d) Expand the Databases folder.
e) Right click the DiaMed database.
f) Select Tasks --> Detach
g) Click OK on the Detach Database dialog.
Step 3 - Move the database files.
a) Find the files DiaMed.mdf and DiaMed_Log.ldf
b) Move both files to the new server and place in the desired location.
Step 4 - Attach the database files
a) Connect to new server using SA or an administrator login.
b) Once connected, expand the server.
c) Right click on the Databases folder.
d) Click Add on the Attach Database dialog
e) Select DiaMed.mdf and click OK.
f) Confirm that the Current File Path fields are correct for both
DiaMed.mdf and DiaMed_log.ldf.
g) Click OK.
Step 5 - Creating New DiaMedApp User
a) Expand the Security folder.
b) Right click the Logins folder and click New Login...
c) Use the following information to create a login
Login Name: DiaMedApp
Select SQL Server Authentication
Password: <<Request Password From Chiron Data Support>>
Click OK
Step 6 - Assigning DiaMedApp User to the DiaMed Database
a) Expand the Databases\DiaMed\Security\Users folder
b) Right click on Users and click New User...
c) Enter information below:
User Name: DiaMedApp
Login Name: DiaMedApp
Role Members: db_owner
d) Click OK
At this point, the DiaMed database move is complete and the client can be configured. For instructions on this process, see the article Configuring the Client Connection.