There are hundreds of locations worldwide that are using Noah configured with a Microsoft SQL Server database. Many of these installations have separated the Noah application from the SQL database. In some cases, the location may want to update to a new SQL Server machine. In this case they will need to switch Noah to look to this new SQL Server database.

First, the new SQL Server machine will need to have an instance installed according to HIMSA recommendations and have the Noah SQL database restored to the new instance.

Then, Noah needs to be able to locate that new machine and instance, we need to edit the connection string to point to the new database server.

If you are using Noah 4.8 or higher you will edit the connection string using the Noah4DBConverter.exe located at C:\Program Files (x86)\HIMSA\Noah 4.

1. Launch the tool, choose MigrateEdit Configuration file

2. Make appropriate changes to the Server connection parameters. For more detail on these parameters see Step 4 in the Configuring Noah with SQL Server directions here:

3. Select OK when you have completed making changes in the Edit Configuration file window

4. You will NOT be creating the database files or exporting data as it already exists from the Restore on the new database server

Choose Migrate and Test MSSQL database connection, if all is set correctly, you will get an OK.

5. Close the Noah 4 DB Converter

6. Restart the Noah Server service and Noah Client service

7. At this point, your Noah 4 should be looking at the new SQL Server machine and Noah database. To verify this, you can add a test patient in Noah and locate it in the Patient table in the SQL Database.

If you are using Noah 4.7 you will need to do the following to gain access to the Noah 4 SQLCE2MSSQL utility

When you launch the Noah 4 SQLCE2MSSQL utility after Noah is configured with SQL Server, you will get a message:

If you need to switch to a new SQL Server machine, you will need to point Noah back to the local CE database so the utility can be launched again, and edit the configuration string with the new details.

1. To switch Noah back to the local CE database, download and run the CE reregister.bat located via a link to the right on this page.

2. Launch the Noah 4 SQLCE2MSSQL utility 

3. Follow steps 1-6 above.

4. Select Settings file update from the Migrate menu. Navigate to and select the NOAHDatabaseCore.dll file in the Noah 4 folder (ex C:\Program Files (x86)\HIMSA\Noah )

5. Once you have selected Open on the NOAHDatabase.Core.dll, you will be prompted to restart the NOAH Server Service. Click OK, Close the utility

6. Navigate to Services and stop the Noah Client service, restart the Noah Server Service, start the Noah Client service. Or reboot.

7. At this point, your Noah 4 should be looking at the new SQL Server machine and Noah database. To verify this, you can add a test patient in Noah and locate it in the Patient table in the SQL Database.