[MOVED] Have your application automatically deploy schema changes to your backend SQL Server
with SSW SQL Deploy
How many times have you deployed an initial version of your SQL Server or SQL Server Express Database
application to your clients or departments, then wondered how you are going to make
updates to the Database schema in the future without hassle?
SSW SQL Deploy solves this problem by automatically performing Database updates as a
part of your application deployment. Bundle SSW SQL Deploy when you distribute a
new version of your application to clients and all your database changes will happen
Simply save database changes from SQL Server Management Studio as scripts and this utility enables automatic version upgrades. SSW
SQL Deploy uses SQL Server or SQL Server Express and is designed for Winforms, Webforms, VB, ASP
and Access applications (and more), SSW SQL Deploy means you never have to worry
about your client's data when deploying applications again!
When you distribute a new version of your application to your clients using SSW SQL
Deploy, it automatically applies any pending SQL scripts and Database updates.
It is common practice to save Database schema changes as SQL script files to apply
at a later stage. SSW SQL Deploy works with this practice by applying all of the scripts
in a directory and adding versioning information to the Database after it applies
the SQL scripts.
SSW SQL Deploy can be used directly via its user interface or called from your application.
You can use trickle down deployment for front end, now you can use SSW SQL Deploy for
SSW SQL Deploy means you never have to worry about your Clients' data when deploying
Have a look at SQL Deploy in action:
Video: SSW SQL Deploy in action
[MOVED] Key Features and Benefits
SSW SQL Deploy is so easy to use that it should be a part of every application developer's
software deployment strategy. The main features of SSW SQL Deploy are:
- No new dev tools ?keep using SQL Management Studio
- Completely automate deployment of SQL Server changes
- Easily integrate into your own application
- Run as a standalone application
- Extremely Fast! 440% faster than osql
- Designed for SQL Server 2005 & SQL Server 2008
SSW SQL Deploy is FAST! On a single 600K script file, these are the results you
would typically see over the built in osql.exe tool. It is normally around 5 times
faster, as you can see below. You will save even more time running larger scripts,
especially those scripts that include data as well.
SSW SQL Deploy
Microsoft SQL Server OSQL.EXE Utility
2 minutes 58 seconds
It runs in three modes:
Mode 1 - Directory
Apply multiple SQL script files on the Database.
Figure: SSW SQL Deploy automatically performs Database updates as a part of your
Mode 2 - Compare Scripts
While SSW SQL Deploy manages a SQL Server Database, use SSW
Data PRO! to manage an Access Database.
The compare scripts mode allows you to check that the saved SQL scripts contain
all of the changes to your Database.
In this mode SSW SQL Deploy creates a temporary Database then compares the temporary
Database structure to your existing Database. Any differences in the SQL scripts
are then displayed.
Mode 3 - Single SQL script
Runs a single SQL script against the Database.
More screen shots in the User Guide
SSW SQL Deploy Options New!
How did this product eventuate?
We developed a custom rich client product for Tennis Australia which was installed
in many locations around Australia. Every time a new version was deployed (which
was too often :-) we had to manually dial in to run some SQL scripts - SQL Deploy
was developed and completely removed this deployment problem.
SSW SQL Deploy now boasts an Options form that can easily be integrated into your
application. This options form will let you select a database for the application
(either create or select an existing one). Once selected, the database can be upgraded
depending on the scripts that you have placed in the scripts folder. The statistics
of the database are shown for your convenience, and the compare function is implemented
to ensure your database structure is up to date with the scripts. Instructions on
how to use this control can be
- Figure: Connecting to your SQL database with SSW SQL Deploy is quick and easy
[MOVED] System Requirements
[MOVED] What does the unregistered version give me?
In respect to the unregistered version we know you want to see it working before
you buy it. We aim for that.
Note: we also give free version targeted to the little guys
More details see http://www.ssw.com.au/ssw/KB/KB.aspx?KBID=Q658302
SSW provides free phone and email support to answer queries on registered products.
If you can't find it in the product documentation then check our
knowledge base for further information and tips about SSW SQL Deploy.
Please send us bug reports
and feedback so that we can
evolve our software into a product that matches your requirements. We guarantee
[MOVED] I'm Sold... What's next?
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft
Corporation in the United States and/or other countries.