distal-attribute
distal-attribute
distal-attribute
distal-attribute

Question about table views

HWI posted 7 years ago in General
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.
ansgar posted 7 years ago
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?
HWI posted 7 years ago
Oki, I posted it to the bug Tracker.

Thanks for the answer.
ansgar posted 7 years ago
Thank you!
muzza4 posted 6 years ago
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

Please login to leave a reply, or register at first.