SQL Server Support

ModelRight 4.1 supports SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2017, 2019.

Here is a partial list of the SQL Server objects and properties that are supported in ModelRight 4.1.  ModelRight 4.1 can Reverse Engineer, Forward Engineer (Generate SQL DDL), and Compare these objects and properties with an existing database or other Model.  

•Tables - SQL Server-specific properties like Filegroups, Text Image Filegroups, Partition Schemes, etc...

•Columns - Computed Columns, SQL Server-specific properties like IDENTITY, Not for Replication, Collation, ROWGUIDCOL, FILESTREAM, Collation

•Views - SQL Server-specific properties like WITH CHECK, ENCRYPTION, etc...

•Indexes - SQL Server-specific properties like Clustered, FILLFACTOR, FILEGROUP, ALLOW_ROW_LOCKS, etc..

•Fulltext Indexes and Fulltext Catalogs

•Key Constraints

•Check Constraints - Table and Column level

•Triggers - DDL and DML

•Types - Alias, External, and Inline

•Defaults - generated as DEFAULTS or inline

•Rules - generates as RULES or Check Constraints

•Partition Schemes and Partition Functions

•Procedures and Functions

•Assembly

•Synonym

•Schemas

•Template support for many of the above object types lets you categorize and re-use

Note: To connect to SQL Server either select an ODBC data source from the drop down list, enter the name of a server (or server/database or server,port/database, or machine/server/database), or enter a connection string (http://msdn.microsoft.com/en-us/library/ms130822.aspx). If you enter a connection string, then you need to fully specify all the parameters (the server, user, password..)
To create an ODBC data source, bring up the Control Panel, select Administrative Tools, and then select Data Sources (ODBC).   Click on the Add button and then the SQL Server driver.  Proceed with the rest of the wizard.

Windows Authentication to a remote server is not supported.