Moving the DiaMed Database
  • RSS Feed

Last modified on 7/9/2015 9:37 AM by User.

Tags:

Moving the DiaMed Database

 

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