Advanced Serial Data Logger - RS232 to MS SQL Server. Logging data from RS-232 to MSSQL Server database

Trust In Confidence!

For Windows 2000 - Windows 10 (2016) (incl. Server, x86 and x64). Latest version: 4.1.19 build 1202. .

 

RS232 to MS SQL Server using our data logger software

Complete the following steps in order to configure our software for data logging from RS232 to SQL Server. If you are not familiar with the SQL dialect, then please use the RS232 to ODBC method instead. ODBC drivers for SQL Server are includes in Windows Vista, Windows 7 and higher.

1. RS-232 Logger Software download

Download and install our software.

Download Advanced Serial Data Logger

Advanced Serial Data Logger and all necessary plugins you can download from our download area. Plugins can be downloaded separately here.

You will need the following plug-ins:

  • The "ASCII Data Parser" plug-in to extract data from the common data flow (already included in the installation package).
  • The "SQL Database Pro" plug-in to export data from RS232 to the MS SQL Server database. This plug-in will connect to the SQL Server directly and requires SQL Server Client tools..

The following diagram illustrates the internal data flow from RS232 to MSSQL.

 

RS232 to MSSQL data flow

 

2. Configure the ASCII data parser

RS232 data parser

Our tutorials section contains several examples for different data formats. Also, our support team will glad to help you with the parser settings.

3. Create a SQL Server database and table with a necessary structure

Microsoft SQL Server Management Studio

You can easily do it with help of Microsoft SQL Server Management Studio. Also you may use any third party tool for it. Don't forget to grant necessary rights for the new table.

4. Configure a connection in the SQL Database Pro plug-in

MySQL data export

You can find the detailed description in the following tutorial.

5. Specify a SQL statement to insert RS232 data to Microsoft SQL Server

 

 

RS-232 to SQL Server Glossary

RS232 Port, RS232, RS-232 - usually identifies serial ports more or less compliant to the RS-232 standard.

MS SQL Server - a relational database server, developed by Microsoft.