How does one copy tables, views, etc. from one database to another?
704213May 29 2009 — edited Jun 2 2009I do not have a strong DBA background but have been placed in charge of updating and migrating a number of tables and views across multiple databases.
For the future I need a better workflow than exporting and importing tables to/from .csv files and copy and pasting the SQL from each individual view.
Can somebody point me in the right direction? I'm happy to do some reading but have no idea where to look.