1) In target designer first create a target with all the necessary columns.
2) Then click Target--> Generate/Execute SQL.
3) A popup like below is shown:
4) Here we give the filename which will contain the create DDL query.
5) Then we connect to the database where we need to create the table using "Connect" button.
6) Then select the tables for which we need to generate and also select "Generation options" as required.
7) Click the "Generate SQL file " button . This will put the DDL in the filename we mentioned.
8) We can click "Edit SQL file" to edit the file..ex: changing the database name and making small changes to the column definitions.
9) Then click "Execute SQL file". In the output window you will see the result of the execution.
10) We can even click "Generate and Execute" if we want to generate and directly execute the DDL.
2) Then click Target--> Generate/Execute SQL.
3) A popup like below is shown:
5) Then we connect to the database where we need to create the table using "Connect" button.
6) Then select the tables for which we need to generate and also select "Generation options" as required.
7) Click the "Generate SQL file " button . This will put the DDL in the filename we mentioned.
8) We can click "Edit SQL file" to edit the file..ex: changing the database name and making small changes to the column definitions.
9) Then click "Execute SQL file". In the output window you will see the result of the execution.
10) We can even click "Generate and Execute" if we want to generate and directly execute the DDL.
This doesn't work for Salesforce objects unfortunately. Is there a way to automatically create the target tables that match the SF source tables?
ReplyDelete