SQL Server Support
|Top Previous Next|
ModelRight 4.0 supports SQL Server 2000, 2005, 2008, 2012 and 2014.
Here is a partial list of the SQL Server objects and properties that are supported in ModelRight 4.0. ModelRight 4.0 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
•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
•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..)
Windows Authentication to a remote server is not supported.