Hi,

Our understanding is that, adding Projection option in Export Data Window below view as mention in the snapshot "Projection".and when we "Generate Aquascript " then aquascript file should contains the extraction logic of projection and the functionality should be same as Table and View Extraction?

Thanks

Hi Pankaj,

You are looking in the wrong spot..  This change has to do with the project templates.

Here is the test case...

1) Click on the Projects tab seen here.

2) Right click on project and select new project seen here.

3) New Project menu comes up.  Select "Database Schema and Data Exporter" seen here.

4) Select the Server Connection - Should be your Vertica server connection.

5) Select the Export Folder - Folder that you want to put the extracted data.

6) Click Create.

7) Projects files are added, javascript template is created and template is opened in the editor as seen here. Note that I am using PostgreSQL for this example.

8) Click the Run button seen here.

9) Output data will be located in the specified folder as data and ddl seen here.

10) Output messages will be located at the bottom of the screen seen here.

Here is where some of the code changes have to happen...

1) ExportDatabaseToCSVTemplate.vm seen here.  When making changes to this file do not use blanks always use tabs. Do not format this file when you check it into svn.

2) CoreMetadata.java seen here. The template above calls these extraction methods. See the example for sequences. You will have to code up a new extraction method for projections and then create the underlying database extractions. Some might already be there already. Please check before coding up new ones.

Let me know if you have questions...

Thanks, Tom

Reopening - Please review the note to Kunal and make changes.

Tom,

Fixed review comments.

This issue is verified.

Code Reviewed.