change datasource of a freehand view
I have a freehand view (no virtual table) with a certain SQL query. Now I would like to point that view to a different database. As the change datasource option is (as far as I can see) only available for views build from with GUI I supposed that the correct way was to do an export and import.
When I do that an custom import the view I can add the view where I can change the folder / subfolder and the datasource. This works but an extra version of the view is generated attached to the correct datasource but no reports linked.
When I choose for replace existing I can point to the original view but then I am unable to alter the datasource. Changing the datasource mapping in the settings of the import and then replace existing results in no change in the datasource.
How to change a datasource for a freehand SQL. The structure of both databases is the same.