Sourcetable Integration

Export DBVisualizer to CSV

Jump to


    Welcome to our comprehensive guide on how to export data from DBVisualizer to CSV files, a valuable skill for professionals working with large datasets that exceed memory constraints when viewed directly in the application. CSV exports facilitate the analysis and sharing of data by allowing users to view query results in spreadsheet applications, where further data manipulation and visualization can be performed. In this guide, we'll explore the essentials of DBVisualizer, provide step-by-step instructions on exporting query results to CSV, discuss various use cases for this functionality, and introduce Sourcetable as an alternative export method with a diverse range of formats. Additionally, we'll address common questions about the export process to ensure you have all the information needed to optimize your data handling tasks.

    Exporting Data to CSV in DBVisualizer

    Using the @export Command

    To export query results to a CSV file using DBVisualizer, you must utilize the @export command. This command enables the export of one or more queries' results directly to a file. By executing the @export on command, you initiate the export process. You then define your export parameters, such as the filename and format, with the @export set command. After running your queries, the @export off command is used to cease the export operation. It's essential to note that exporting to a file can be particularly beneficial when dealing with very large results or when there are memory constraints.

    Setting Export Parameters

    The @export set command is crucial for setting up the export operation. It accepts various parameters, but the filename parameter is the only one that is mandatory. When specifying the filename parameter, the file path and name are case-insensitive and should reflect the desired location and name of your output file. In case there is no file extension provided, the filename parameter will default to using the CSV format. To specify the file format explicitly, you can include the appropriate file extension in the filename parameter.

    Example of Exporting to CSV

    An example of a script to export data to a CSV file in DBVisualizer is as follows:

    @export on;@export set filename="c:\Backups\Orders.csv";select * from Orders;@export off;

    This script begins by turning on the export function, sets the filename for the CSV file where the data will be stored, executes a query to select all records from the Orders table, and then turns off the export function.

    Handling Large Query Results

    For large query results, the @export command can be used in tandem with the @set maxrows command to override the Max Rows field value in the SQL Commander tab toolbar. This allows you to handle large datasets more effectively by limiting the number of rows exported to the CSV file or by allowing for the export of all rows if required.

    Memory Considerations

    It's important to acknowledge that DBVisualizer may use more memory than expected when exporting query results. To mitigate this, using the @export command is recommended as it helps manage memory usage more efficiently, especially when exporting large results or when the system has memory constraints.

    Sourcetable Integration

    Streamline Your Data Management with Sourcetable

    Transitioning data from DBVisualizer to a spreadsheet format can often be a cumbersome process, involving exporting to CSV files and then importing them into your chosen spreadsheet application. Sourcetable offers a superior alternative that not only simplifies this process but also enhances it. With its ability to sync live data from a wide array of apps and databases, including DBVisualizer, Sourcetable automatically pulls in your data, effectively eliminating the tedious export and import steps.

    By leveraging Sourcetable for your data management needs, you gain the benefit of real-time data updates, ensuring that your spreadsheet always reflects the most current information without manual intervention. The familiar spreadsheet interface of Sourcetable allows for easy querying and manipulation of your data, which is ideal for automation and developing business intelligence insights. Choose Sourcetable to optimize your workflow, save time, and make more informed decisions.

    Common Use Cases

    • D
      Sourcetable Integration
      Use case 1: Exporting large query results to a CSV file to prevent memory constraints during data analysis
    • D
      Sourcetable Integration
      Use case 2: Automating the process of data extraction by using a script with @export commands for periodic reporting
    • D
      Sourcetable Integration
      Use case 3: Appending new query results to an existing CSV file for cumulative data collection
    • D
      Sourcetable Integration
      Use case 4: Limiting the number of rows in an export to a CSV file with the maxrows parameter for focused data studies

    Frequently Asked Questions

    Do I need a special version of DbVisualizer to export query results to CSV?

    Yes, exporting query results to CSV is only available in the DbVisualizer Pro edition.

    How do I start and end the export process in DbVisualizer?

    To start exporting a query result, use the @export on command. To end the export, use the @export off command.

    What command do I use to set the filename and format for the exported file?

    Use the @export set command to specify export options, including the filename and format. The filename parameter is required and determines the name and format of the exported file.

    Can I export query results in formats other than CSV?

    Yes, while CSV is the default format, you can also export to formats such as HTML, XML, SQL, XLS, and JSON by specifying the format in the filename parameter.

    Why might I prefer to export query results instead of viewing them in the Result Set grid?

    Exporting to a file might be preferred for very large results due to memory constraints, as it may be more efficient than viewing them in grids.


    Utilizing DBVisualizer's export functionality is a straightforward process that enhances data manipulation and sharing. By initiating the export with the @export on command, you can seamlessly transfer your query results into a file. The @export set command allows you to tailor your export preferences, while the @export off command halts the export process. Remember, the filename parameter is essential, as it determines the destination file's name. With CSV being the default format, there is no need to specify it, simplifying the procedure even further. Instead of exporting to a CSV file, consider using Sourcetable to directly import your data into a spreadsheet, providing a more efficient workflow. Sign up for Sourcetable today to get started and streamline your data management.

    Start working with Live Data

    Analyze data, automate reports and create live dashboards
    for all your business applications, without code. Get unlimited access free for 14 days.