There is no copy/paste view UI feature, here is a workaround solution (use "update view..." menu item),
1) step1, click "Update View..." to generate code
2) Select the target connection and database
It is equivalent to recreating the view in the target database
Hi Qinghai, Thanks for the prompt response.This confirms that moving your whole database to another server/prod means you need to manually re-create the Views.
This workaround is only applicable to a single view, and it is obviously not easy to use for the views of the entire database. We will add this feature to the to-do list and allow all views to be rebuilt when copying the database
Tyvm. Would love to see that in future releases.
Resolved in 5.2.5. the database read-only views are also rebuilt when the database is copied.
Replies have been locked on this page!