{{announcement.body}}
{{announcement.title}}

Comparison of MS SQL Server Data Modeling Tools: Data Types

DZone 's Guide to

Comparison of MS SQL Server Data Modeling Tools: Data Types

In this article, see a comparison of MS SQL Server data modeling tools and data types.

· Database Zone ·
Free Resource

Two laptops back to back

Comparison of MS SQL Server Data Modeling Tools

This table lists the most widely used data modeling tools currently in use. Tools are compared to Microsoft SQL Server (MSS) supported type. Note that the comparison concerns the support of the 2016 and 2017 SSM version.

  Dezign for Databases 10.0.2

ERBuilder

2.1.6

ERStudio 17 ERWin 9.8 Navicat Data Modeler Essentials 2.1.1 PowerDesigner 16.6 TMS Data Modeler 3.2.4.0 Toad Data modeler 6.5.4  
 
 
MSS Version 2016 2016 2017 2016 2016 2016 2017 2016 2016 2016 2017  
BIGINT * * * * * * * * * * *  
BINARY * * * * * * * * * * *  
BINARY VARYING * * *         *        
BINARY VARYING(MAX)   * *         *        
BIT * * * * * * * * * * *  
CHAR * * * * * * * * * * *  
CHAR VARYING * * *   *     *        
CHAR VARYING(MAX)   * *                  
CHARACTER * * *   *     *        
CHARACTER VARYING * * *   *     *        
CHARACTER VARYING(MAX)   * *                  
COMPUTEDFIELD * * *     * *   * * *  
CURSOR               *        
DATE * * * * * * * * * * *  
DATETIME * * * * * * * * * * *  
DATETIME2 * * * * * * * * * * *  
DATETIMEOFFSET * * * * * * * * * * *  
DEC * * *         *        
DECIMAL * * * * * * * * * * *  
DOUBLE PRECISION * * * * *     *        
FLOAT * * * * * * * * * * *  
GEOGRAPHY * * * * * * * * * * *  
GEOMETRY * * * * * * * * * * *  
HIERARCHYID * * * * * * * * * * *  
IMAGE * * * * * * * * * * *  
INT   * * * * * * * *      
INTEGER * * *   *     *   * *  
MONEY * * * * * * * * * * *  
NATIONAL CHAR   * *   *     *        
NATIONAL CHAR VARYING   * *   *     *        
NATIONAL CHAR VARYING(MAX)   * *         *        
NATIONAL CHARACTER   * *   *     *        
NATIONAL CHARACTER VARYING   * *   *     *        
NATIONAL CHARACTER VARYING(MAX)   * *         *        
NATIONAL TEXT   * *   *     *        
NCHAR * * * * * * * * * * *  
NTEXT * * * * * * * * * * *  
NUMERIC * * * * * * * * * * *  
NVARCHAR * * * * * * * * * * *  
NVARCHAR(MAX)   * *   * * * * * * *  
REAL * * * * * * * * * * *  
ROWVERSION   * * * *         * *  
SMALLDATETIME * * * * * * * * * * *  
SMALLINT * * * * * * * * * * *  
SMALLMONEY * * * * * * * * * * *  
SQL_VARIANT * * * * * * * * * * *  
SYSNAME * * *   * * * *   * *  
TABLE               *        
TEXT * * * * * * * * * * *  
TIME * * * * * * * * * * *  
TIMESTAMP * * * * * * * * *      
TINYINT * * * * * * * * * * *  
UNIQUEIDENTIFIER * * * * * * * * * * *  
VARBINARY * * * * * * * * * * *  
VARBINARY(MAX)   * *   * * * * * * *  
VARCHAR * * * * * * * * * * *  
VARCHAR(MAX)   * *   * * * * * * *  
XML * * * * * * * * * * *  

We note that among the Data Modeling tools that cover the majority of types, we have the “PowerDesigner 16.6’’ and “ERBuilder 2.1.6’’ tool. However, unlike PowerDesigner, ERBuilder supports CHARACTER VARYING(MAX) while PowerDesigner supports cursor and Table.

Please leave a comment for any suggestions or updates.

Further Reading

Data and Schema Comparison Tools for MS SQL Server Databases (Part 1)

Synchronizing MS SQL Server Databases

Topics:
data ,database ,sql server ,data types ,data modeling software ,comparison

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}