Home
SQL Data Sets - Online help Prev Page Prev Page
Introduction
About SQL Data Sets
Version history
Supported database engines
Contact us
Getting started
Creating a result set package
Opening and using a SQL Data Sets package
Using SQL Data Sets
Connecting to a database server
Conecting to databases directly without client libraries installed
Connecting to an Oracle database
The SQL workspace
SQL editor
Data sets
HTML export
Adding and viewing notes
Viewing images
Creating a package
Exporting to a SQLite database
Options
Using SQL Data Sets Viewer
Opening a package
Local queries
Local SQL commands and functions

Creating a package

Once you have one or more data sets available, you can create a SQL Data Sets package.

To create a package, select the Database > Create SQL Data Sets package menu item

mainmenu-createpackage  

or click on the Create SQL Data Sets package
(export_data) toolbar item. This starts the Create Package wizard. On the first page, select the data sets you want to include in the package.

gs03  

On the second page, enter the name of the file you want to save the package in. You can choose to include the SQL query that generated the data set. You can also choose to secure the file with a password, so that only users who know the password can open the package.

gs12  

Lastly, you can include some informative comments to describe the package you are creating. Users will see your comments as a SQL comment when they open your package.

package05  

Click Next
to create the package. SQL Data Sets displays progress information as it creates the package. Note that your package data is compressed, and you can change the compression level using the Options dialog.

gs05