The NOAH System database, SQL Server 2005 Express Edition, will provide enough storage capacity for most NOAH users. However, for those who need even more data storage space, NOAH System includes the option of connecting to a Microsoft SQL Server database, providing unlimited data storage for larger NOAH installations. Microsoft SQL Server can be purchased directly from Microsoft or other authorized resellers.
Review the information below to decide if configuring your NOAH software to use a SQL Server database is the right choice for your location. If moving to Microsoft SQL Server, see the links on the right for specific directions for your situation.
IMPORTANT considerations before configuring NOAH System to use a SQL Server database:
- It is expected that you have a working knowledge of SQL Server and have the program installed. If you need assistance with installing, setting up, and maintaining your SQL installation you should give serious consideration to obtaining technical support from your IT department or outside consultant.
- HIMSA supports interfacing with SQL Server using the provided HIMSA tools: the NOAH System Migration Wizard, the NOAH Database Properties Program and the NOAH Console.
- HIMSA and HIMSA Member companies will not provide technical assistance using the Microsoft SQL Server tools to backup or manage the NOAH database.
- The NOAH System database needs the support of the NOAH Server application. The NOAH Server application will need to be installed on the same PC with SQL Server.
- NOAH 3.6.1 and NOAH 3.7 are supported with SQL 2000 SP4, SQL 2005/2008 Standard or SQL 2005/2008 Enterprise.
- NOAH System 3.7 is supported with 64-bit versions of SQL Server 2005 and 2008 although special considerations apply.
- Configuring NOAH System to use SQL Server will not mean a change in the supported networking setups for NOAH System. HIMSA will continue to support NOAH in a local, wired, Ethernet network.
- As with previous version of NOAH System, HIMSA will continue its policy of solely controlling access to the database. Most of the data in the NOAH database is stored as binary large objects and the possibility of database corruption is significant when accessing the database directly.