Configure Storage Locations for a Database
When you create a storage location, you can configure the system to maintain the documents and images in a database instead of in a folder of a file system. After you have configured the database storage location and ensured the database has adequate storage capacity, you can use the storage location as the archive path to permanently store the documents and images.
- Select the open menu
button, and then select New.
The Storage Location window opens. - In Storage Type, select the Database option, and then select the database source for storing the images.
If the selected DSN is not the primary NextGen Healthcaredatabase, you must use the following SQL script to create the image storage table in the alternate database:
create table binarydataics ( page_id uniqueidentifier NOT NULL, image_data image, created_by int NOT NULL, create_timestamp datetime NOT NULL DEFAULT getdate(), modified_by int NOT NULL, modify_timestamp datetime NOT NULL DEFAULT getdate(), row_timestamp timestamp NOT NULL ) ALTER TABLE binarydataics ADD CONSTRAINT pk_binarydataics PRIMARY KEY NONCLUSTERED (page_id)The IP Address field displays the selected database IP address.