Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
How to move the MSHIS_2010 database ?

Answered How to move the MSHIS_2010 database ?

  • Friday, June 01, 2012 9:35 AM
     
     
    Sign In to Vote
    0

    We have to suppress an obsolete SQL-server, but, unfortunaltely, it contains the HIS2010-database called "MSHIS_Data" database.

    Question : How to move this database to another SQL server ?

    Of course, we know the Backup & Restore and recreate the HIS user.. But how to make this change taken into count on the HIS 2010 server ?

    We found the SQL in a registre key called "HKLM \Software \Microsoft \MSSQLServer \Client \SuperSocketnetLib \LastConnext"

    Can we modify it ?

    Thanks for answer..

     

All Replies

  • Friday, June 01, 2012 5:56 PM
    Moderator
     
     
    Sign In to Vote
    0

    You can edit the registry value:

    Key: HKLM\software\microsoft\host integration server\hip

    Value: ConnectionString

    Replace the "ServerName" value with the new SQL Server's name.

    This is assuming you are only moving the SQL DB, and not wishing to install HIS on a new machine etc.

    Rob

     
  • Tuesday, June 05, 2012 7:04 AM
     
     
    Sign In to Vote
    0

    Hi Rob,

    Thanks for fast feed-back. I checked the key, but unfortunately she's non-existent. I checked on another HIS server, with same result: "ConnectionString" is non existent. Under HIP, I have only "HIPServicePath" and "TIMLibPath", both REG_SZ. Do you think we can add this key and see what happens ? 

    Best regards.

     
  • Tuesday, June 05, 2012 3:20 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Oh, you know what...d'oh....for whatever reason, I misread the original question - I missed the fact that you were specifically talking about the MSHIS_Data database! My reply was about the MSHIS_HIP database! The former is for "Data Integration" the latter for "Application Integration".

    SORRY, mea culpa, probably the easiest thing is to re-run the Configuration tool (should be in your start menu under Host Integration Server), and select a different SQL Server.

    Charlie, Stephen, Anyone?????? I am not a Data Int person...

    Rob

     
  • Friday, June 22, 2012 2:00 PM
    Owner
     
     
    Sign In to Vote
    0

    As Rob mentioned, the best way to do this is to run the HIS Configuration Tool, go to the Data Integration Settings and then enter a new SQL Server name in the Server Name field.

    The infomation is stored in the registry in the SqlLogConnectionString parameter under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Host Integration Server\Data Integration. If you edit this parameter, you can change the Server parameter in the connection string to point to the new SQL Server system.

    The preferred way would be to use the Confiugration Tool.

    Thanks... 

    Stephen Jackson - MSFT

     
  • Tuesday, June 26, 2012 2:18 PM
     
     
    Sign In to Vote
    0

    Thanks Rob & Stephen for your answers... So I'll use the Configuration tool.

    Best Regards.