Download

Servantt Lite About

Servantt Lite Specifications
Version:
1.4.7
Date added:
Dec. 10, 2020
Date released:
April 7, 2020
Price:
Free
Operating system:
Windows 7, Windows 8, Windows Vista, Windows XP, Windows 2003, Windows Server 2008, Windows, Windows 10, Windows Server 2016,
Downloads last week:
203
Additional Requirements
Not available

Servantt Lite v1.4.7

Synchronize your SQL servers to version-controlled scripts.

Servantt Lite Screenshots


Servantt Lite Editor's review

Full of nice features: Scripts all objects into a standard and logical structure in file system. Comparisons and version-control are only possible when all developers use the same convention. Scripts do not contain environmnent-specific info, so you can compare only what really matters. No database names, system-generated names, or column order differences. Table columns are ordered alphabetically (after primary key columns), so you can compare only what really matters. Object identifiers are normalized with fully qualified names (with schema) and surrounded by brackets. No more worries about creating an object under the wrong schema. SQL Server scripts can be compared to working folder scripts, and differences can be either applied to the Database (creating or updating objects) or to the Scripts. WinMerge is integrated into context-menu so that it's easy to compare between the SQL Server and the working folder. All scripts are created using "CREATE", but Servantt automatically replaces by ALTER when necessary. No more worries about replacing CREATE vs ALTER on each environment. No more dropping/recreating objects. Objects are updated using ALTER so you don't have to worry about losing permissions or scripting different permissions for each environment. Dropping of objects is fully supported. Dropping an object will delete the corresponding script from the working folder, and vice-versa. Working folder can be connected to any version-control like Git, Subversion, TFS, Sourcesafe, or any other. You can even work without version-control. Fixes carriage-return differences (bug in SQL Management Studio). Extracts triggers and tables individually.


Download






Similar Suggested Software

Query, edit, browse, and manage database objects.

Autocomplete and format SQL code in SQL Server Management Studio.

Manage SQL Server database changes in source control.

Convert Visual Basic .NET, VBP, VBG or PDW's Setup.lst file to an .iss Script.

Compare, synchronize heterogenous databases, merge, convert, and migrate data.

Implement a set of SQL sources for the debugging and database synchronization.