Defining the Data Set Definition on the Target Database

Before the project can be loaded, copied or compared from file, the data set definitions (including records and fields) must exist on the target database. Depending on the releases and patch level of your environment, the data set definitions may have different shapes than on the source database.

See Comparing From File

If you have created your own custom data set definition and it does not exist on the target, you can copy the data set definition using an IDE project.

To migrate the data set definition and related objects using IDE project:

  1. On the source database, create a new IDE project in Application Designer. File, and then New, and then Project.

  2. Insert the data set definitions into the IDE project. Insert , and then Definitions into Project, and then select Definition Type: Data set Definitions, and then select the specific data set definitions to include, and then click Insert.

    Insert all the records definitions that are in the data set definition and all the database field definitions that are in the record definitions.

  3. Save the IDE project.

  4. Copy the IDE project to a file. Tools, and then Copy Project, and then To File, and then enter the export directory, and then click Copy.

  5. On the target database, open Application Designer and compare the IDE project from the file. Tools, and then Compare and Report, and then From File.

    It is advisable to run a compare to check whether copying the record and field definitions are the same on the source and target.

  6. On the target database, open Application Designer and copy the IDE project from the file. Tools, and then Copy, and then From File.

Note:

You also have the option of using Copy to Database, if your environment is set up where both the source and target databases are available. If any records were changed or added in the IDE project, it will be necessary to table create or alter to assure that the records exist on the target.