SQL Packager

Packages a database for deployment or update.

Published by Redgate Software
Distributed by ComponentSource since 2005

Screenshot of SQL Packager
i

Please note that SQL Packager was retired on December 3rd 2014

Red Gate has now stopped selling SQL Packager. This means that additional copies of SQL Packager, and extensions to support contracts, are no longer available.
If you have a license for SQL Packager, it will still work and you can keep using it for as long as you like, but Red Gate won't be doing more work on the tool, so unfortunately...

Show more

Please note that SQL Packager was retired on December 3rd 2014

Red Gate has now stopped selling SQL Packager. This means that additional copies of SQL Packager, and extensions to support contracts, are no longer available.
If you have a license for SQL Packager, it will still work and you can keep using it for as long as you like, but Red Gate won't be doing more work on the tool, so unfortunately there won't be any further updates and Red Gate won't be supporting SQL Server 2014 or later.

If you have a SQL Packager Support & Upgrades contract, Red Gate are offering you a free license of SQL Compare Pro and SQL Data Compare Pro. These can be used with the script packaging utility to create packages as you would with SQL Packager. To claim your licenses, contact support@red-gate.com

About SQL Packager

Packages a database for deployment or update.

SQL Packager enables you to package the structure and contents of a Microsoft SQL Server database or database upgrade into a .NET executable file or a C# project, so that installing a database is much simpler. You can use SQL Packager to package the database structure, data, or both, for installation or deployment. SQL Packager also enables you to compress your package for reduced storage overheads, and faster deployment and distribution of databases. It is perfect for packaging up pre-existing SQL scripts, whether generated by SQL Packager or externally. This feature makes it very simple to save out a new creation script, modify it or add comments for your client, and then simply repackage the modified SQL script. You can use SQL Packager to package SQL Server 2012, 2008, 2005 and 2000 databases.

SQL Packager works by scripting and compressing the entire database – schema and data together – and packaging it up as a deliverable .exe file. It does this by scripting separate transactions for schema and data respectively. Highly customizable options enable you to generate package scripts to exactly fit your needs.

When migrating databases, all schema objects, all new tables and their data as well as data with unique indexes or constraints are also scripted.

Installing, updating, or distributing your database now becomes a simple point-and-click procedure. Deploy SQL Server databases, and your applications that depend on them, with no manual scripting. Exploit the command line options to automate the installation of database updates remotely.

By letting you compress your packaged database, you can reduce storage overhead and distribute it faster and more easily. SQL Packager also makes it easy to archive your database, and is an excellent solution for making a backup of your database where you don't have SQL Server administration rights.

SQL Packager Benefits:

  • Easy roll-out of database updates across your client base
  • Script and compress your schema and data accurately and quickly
  • Package any pre-existing SQL script as a .exe, or launch as a C# project
  • Simplify deployments and updates for SQL Server 2000, 2005 and 2008