Frequently the controls expert who knows about Rockwell Allen-Bradley tags is not the same person as the database expert who knows about Microsoft SQL Server tables.

Can't we all just get along?

Can’t we all just get along?

But we can still all get along.

Here’s a cross reference for a few basic Allen-Bradley tag types versus data types in Microsoft SQL Server 2008 and 2012 that might be helpful in bridging that gap.

PLC Database
BOOL bit
SINT tinyint or char(1) depending on use
INT smallint
DINT int
REAL real
STRING varchar

Allen-Bradley defines a whole lot of structured data types. A structured data type has members that each have their own data type. But the above basic types should help start the conversation, I hope.

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available