Question about table views
| User, date | Message |
|---|---|
|
Written by HWI
5 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
5 years ago 3949 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
5 years ago 2 posts since Wed, 12 Dec 07 |
Oki, I posted it to the bug Tracker. Thanks for the answer. |
|
Written by ansgar
5 years ago 3949 posts since Fri, 07 Apr 06 |
Thank you! |
|
Written by muzza4
5 years ago 50 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. |