User's guide (NO)




DUP Designer screenshots

DUP Designer is the developer's tool. DUP Designer lets you create DUP files with all sorts of database statements:

  • SQL script statements (DDL and DML)
  • Data uploads
  • Java classes

This makes the DUP file to an all-in-one update package that your customer will receive and process locally with DUP Processor. 

When you open a DUP file in DUP Designer, the statement grid gives you a quick overview of file contents. The lower half of the DUP window displays details of the selected statement.

The purpose of the DUP file displayed in screenshots below, is 

  1. create a new table
  2. upload data
  3. add a column and a constraint to an existing table.

Let us walk through this example, and take a quick stop at the most important details.

The first statement is always a Logon statement. Leave blank all fields you want your customers to fill in. In most cases you enter a username and password, and your customer only needs to enter the connection string to his local database. 

The second statement is a Version statement which checks existing version number. Here you set the schema version the customer must have as a prerequsite before the DUP file can be processed. This mechanism prevents users from processing files in a wrong order.

The third statement is a SQL statement. Here you enter any SQL, for instance create a table.

The fourth statement is a Data upload statement. Data upload statements are useful because they eliminate the need writing numerous "INSERT INTO". With DUP Designer you retrieve data from a source table. Data will be compressed and stored in the DUP file. Then you just have to choose the upload method for loading the data into your customer's database.

The fifth and sixth statements are SQL statements like the third. The seventh and final statement is a Version statement that updates the schema's version number.

After processing this file, your customer will have the new properly installed!

DupSoft (C) 2013