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

Question about table views

User, date Message
Written by HWI
7 years ago
Category: General
2 posts since Wed, 12 Dec 07
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.
Written by ansgar
7 years ago
4979 posts since Fri, 07 Apr 06
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?
Written by HWI
7 years ago
2 posts since Wed, 12 Dec 07
Oki, I posted it to the bug Tracker.

Thanks for the answer.
Written by ansgar
7 years ago
4979 posts since Fri, 07 Apr 06
Thank you!
Written by muzza4
6 years ago
51 posts since Mon, 04 Dec 06
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.