Deploying a database upgrade with your product
The situation
Your software application incorporates a Microsoft SQL Server or MSDE database. You have upgraded the application and the database, and you want to install the upgrade to the database schema and data along with the product.
Key challenges
- Seamlessly incorporating the database upgrade with the installation of your product.
How we can solve it
- Use SQL Packager to package your database as a .NET executable.
- Select the updated objects and data that you want to be deployed.
- Preview the SQL code that will be used to create the schema and data.
- Generate the package, using compression.
- Include the SQL Packager™ .NET executable and associated DLL files as language-independent support files in your installer.
- Set up a custom action to launch the database installation executable, using SQL Packager's command line interface, and place it in the appropriate place in the installation execution sequence.
Benefits of our solution
- SQL Packager enables you to install the upgrade to the database as part of the standard installation procedure.
- You can optionally compress the package to reduce transfer and upload times.
- You can optionally create a C# project so that you can customize the package.
Case studies
- SQL Bundle Developer Edition helps building company customize installation and upgrades of key SQL databases
- Exia combines SQL Packager with InstallShield for easy installation and set up of web application
- SQL Data Compare™ and SQL Packager help iCOMCept ensure customer's database accuracy
Online help
- SQL Packager: Upgrading the Database Structure and Data