The table describes tasks you can perform with Database Toolbox™ functions and tasks you can perform with Visual Query Builder.
|Database Toolbox Functions||Visual Query Builder|
Retrieve large data sets or partial data sets in a single fetch command, or in discrete amounts using multiple fetches.
Import data from relational databases into the MATLAB® workspace by selecting information from lists to build queries.
Dynamically import data into the MATLAB workspace.
Display retrieved information in relational tables, reports, and charts.
Modify SQL queries in MATLAB statements.
Easily build SQL queries and exchange data between databases and the MATLAB workspace.
Write MATLAB files and applications that access databases.
View and edit SQL statements for queries generated with VQB.
Replace existing records in databases with data from the MATLAB workspace.
Automatically generate a MATLAB file that consists of Database Toolbox functions that perform queries you built using VQB.
Export binary data or other data types.
Export data from the MATLAB workspace into new records in a database.
Access database metadata.
You can use Visual Query Builder for most, but not all, of the tasks you can do with Database Toolbox functions. The limitations of Visual Query Builder are as follows:
You cannot use Visual Query Builder to replace existing data in a database with data from the MATLAB workspace. Use the update function instead.
You cannot use Visual Query Builder to export binary data. Instead, use the fastinsert function.
You cannot use Visual Query Builder to access database metadata.