Servantt Lite Icon

Servantt Lite

Synchronize your SQL servers to version-controlled scripts.

Servantt LiteOverview

Servantt is a tool for Developers, DBAs and Data Administrators that makes it easy to reverse-engineer your database objects, compare database to the scripts, update the scripts or apply the changes to the SQL server.Now you can keep track of your SQL objects in your favorite version control (Git, TFS, Subversion, SourceSafe, etc), and quickly deploy those changes back to the SQL server.

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.

Servantt Lite is a freeware tool for helping you correctly keep your SQL objects into source control.It is fully functional, does not have any limitation, and is free for personal and commercial use. And will always be free.

NEW

Fixed some bugs.

Servantt LiteInformation

Version
1.4.7
Date
02.02.20
License
Free
Language
English
File Size
6.03MB
Category
SubCategory
Operating Systems
Windows XP/2003/Vista/Server 2008/7/8/Server 2016/10
System Requirements
No additional system requirements.
Castellum Icon
Migrate source-code repositories from Microsoft SourceSafe to Git repositories.
Demo
Krepost Icon
Move source-code repositories from Microsoft SourceSafe to Subversion repositories.
Demo
More
MySQL Query Browser Icon
The easiest visual tool for creating, executing, and optimizing SQL queries
Free
CASE Studio 2 Icon
Create ER diagrams for various databases, generate SQL scripts, HTML reports
Paid
Crystal Reports Server XI Icon
Transforming data into actionable information accessible anytime, anywhere
Trial
One-Click SQL Restore Icon
This simple free tool restores full MS SQL server database backups.
Free
Statement Tracer for Oracle Icon
A free solution for debugging programs interfacing with the Oracle RDBMS.
Free
DBF Explorer Icon
DBF Explorer is an application for viewing and editing DBF files (dBase III).
Free
SQL Prompt Icon
Intelligent code completion and layout for MS SQL Server
Paid
ACCDB Password Icon
Recover passwords in Microsoft Access (accdb, accde, accdm) databases.
Demo
More