Configuring an MS SQL Database for Upload to Database feature

 

Black Ice Software provides a single click solution to print, convert and save any document directly to SQL database through an ODBC Data Source. One of the most reliable SQL database solution is the Microsoft’s MS SQL Server.

 

To start configuring a database for MS SQL, at first step, one has to install the MS SQL to the computer, where the database will be stored. Microsoft offers a wide variety of editions from small and simple database requirements to enterprises. For the seamless database management, SQL Server Management Studio (SSMS) is also recommended.

 

Once the MS SQL and SSMS is installed, start the SSMS.

 

Login using the default settings, which is Windows Authentication.

 

cid:image002.png@01D58F22.9FF8A430

 

On the left-pane, right click on Databases > New Database

 

cid:image004.jpg@01D58F25.441311C0

 

On the New Database window, enter a Database name, and press OK to create the database.

 

cid:image006.jpg@01D58F25.441311C0

 

Expand the newly created database under Databases, click right-click on the Tables folder. Go to New > Table…

 

cid:image008.jpg@01D58F25.441311C0

 

In the center of the screen, enter the fields/columns of the new table.

 

cid:image010.jpg@01D58F25.441311C0

 

Depending on how one would like to upload the documents, different table structure is required. In this example, one should create a table to upload Documents in binary (entire document).

 

ID column will be a unique identifier for the records in the table. This column is highly recommended, since the Document ID/Index of the uploaded document is not necessarily unique for each document. This column Data Type must be bigint.

 

DocumentBinary column will store the document itself. This column Data Type must be varbinary(MAX).

NOTE: In case you would like to upload the Document Path instead of the Binary, the Data Type must be varchar.

 

DocumentID column will store the document ID/Index. This column Data Type must be varchar(N). N is the maximum length of the Document ID. If you plan to work with very long Document IDs, then it’s recommended to enter a number larger than 1000.

 

cid:image012.jpg@01D58F25.441311C0

 

Since ID is going to be a unique identifier, this column requires further adjustments. Select the ID column, and in the Column Properties, change Identity Specification to Yes.

When finished, press the Save icon, and enter a name for the new table to be created.

 

cid:image013.png@01D58F22.9FF8A430

 

The database and table have been successfully created. Now, one has to configure a User for accessing the newly created database. On the left-pane, go to Security > right-click on Logins > New Login…

 

cid:image015.jpg@01D58F25.441311C0

 

Select the SQL Server authentication option. Enter a Login name, and password.

 

cid:image017.jpg@01D58F25.441311C0

 

One should go to User Mappings page, and tick the checkbox of the newly created database. This ensures that the new user will have access to the database.

Select a role for the user. For full access, select the db_owner role.

 

cid:image019.jpg@01D58F25.441311C0

 

Once everything is finished, click on the OK button to create the new user.

 

It’s done, the database is ready to be configured as an ODBC Data Source, and used with the Printer Driver Upload to Database feature.

 

For details about how to configure an ODBC Data Source, please refer to the following link.