LinkedIn
Copied!

Table of Contents

Creating a file containing database updates for import

Version:

Only available versions of this content are shown in the dropdown

You can migrate schema changes from one environment to another using the Import wizard after creating a product file.

Create a product file with new database columns, removed database columns or columns with updated sizes from the target database, then use the Import wizard to migrate schema changes between different environments. For example, you can migrate schema changes from your development environment to your testing environment.

  1. From the navigation pane of Dev Studio, select Records SysAdmin Product .

  2. Click the product containing the schema you want to migrate to another environment.

  3. In the Individual instances to include section, in the Select a class and press 'Query' field, enter the class name of the database table where you want to add the new column, change the column length, or remove a column from the target database with the updated schema.

  4. Click Query.

  5. Select the instances to include and click Submit.

  6. In the File Details section, click Create product file to enter a name for the product file with a .jar or .zip extension, then download the file locally on your machine.

Import the product file using the Import wizard. For more information, see Importing data from a file.
Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.