Generating the Data Movement Script

You can generate the data movement script from the Tools menu.

1. Select Tools > Extended Generation to open the Generation window.
2. Specify a directory in which to generate your data movement files.
3. [optional] Click the Selection tab and specify for which Tables and/or Data Sources you want to generate a data movement script.
4. Click the Options tab and specify your data movement script generation options. You can set the following options:
   
   

   • Use Mappings – specifies whether any previously-created mappings should be used for the data movement

   • Data Movement Method – specifies which kind of script to generate. You can choose between:

     
     

     • Insert Location – [IQ or ASE only] PowerDesigner will create a loadscript for connecting the source database to the IQ server. Note that if the data source is not an IQ or ASE database, then no loadscript will be generated.

     • External File – PowerDesigner will create a dump file from the source database together with a loadscript to upload it to the IQ server.

5. [optional] Click the Generated Files tab to review the names and locations of the files to be generated.
6. Click OK to begin the generation of the data movement script.