How to Import an Entire DB

Where is the functionality to import an Entire DB? I only find the functionality to Import a table?

Hi Kyle,

To import an entire database, you need to execute an SQL script with CREATE statements and INSERT statements. You can generate such a script using the Export Schema feature and then execute it in an SQL Commander tab, ideally using the @run command since the file may be too large to load into the editor.

Please see the Users Guide for details:

http://confluence.dbvis.com/display/UG95/Exporting+a+Schema

http://confluence.dbvis.com/display/UG95/Executing+an+External+Script

Best Regards,

Hans