SqlChangeUp
Consistently create, recreate and update SQL Server databases. Works on a simple
principle of storing the version history information in the database, and only appling
the neccessary changes.
- Works with SQL Server 2005, 2008 and 2008R2, Express, Standard and Enterprise
- Create new databases
- Update existing databases from any prior revision to the current revision
- Optionally insert sample data
- Create testing databases
- Repeatable process eliminates the need to manually change database schema and logic
- Easy to use Windows Interface
- Command Line interface can be used with automated tools including Visual Studio, MSBuild, CruiseControl, Team City and more.
- Can be integrated with your own .Net based deployment or installation software.
No complex licensing or royalties. Your applications may incorporate and distribute SqlChangeUp
to create and update your application specific databases.
Often when developing application software, one or more supporting databases must also be developed at the
same time. With each release of the software, the database tables, views, stored procedures and functions
typically must also change.
However, unlike
the deployment of the application software where the existing files can just be deleted and replaced, the
database cannot be easily
deleted and recreated. The database contains data that cannot be lost. Without a tool such as
SqlChangeUp, typically a manual process is used to apply the changes. However, a manual process
opens the door to mistakes and human error. SqlChangeUp automates the database update process,
allows existing data to be retained and eliminates the possibility for human error.