Question about table views

Hi,

we are working with table views to bundle joins between heavily used tables.

because we develop on different machines we have to export the database quite often.

Unfortunately the export tool from Heidi SQL works very well on tables but ignores views.

Is there any way to automatically transfer all views from one DB to an other one?

At the moment I have to recreate all the views manually.

Views are ignored intentionally currently. The reason: All objects in a db are handled the same way, so the export-dialog would be able to export a view but if you have checked "Export data", it would create redundant data on the target.

The solution is quite obvious: Heidi shouldn't completely ignore views, but just not export the data in them. Should be an easy fix. Any chance you post this to our bugtracker?

Oki, I posted it to the bug Tracker.

Thanks for the answer.

Thank you!

Hi Anse,

[quote="anse"]The solution is quite obvious: Heidi shouldn't completely ignore views, but just not export the data in them. Should be an easy fix.

Just to add my voice, this fix would help me too.

Cheers
Muzza