DBWillow Logo

Import & Export

Overview

DBWillow provides comprehensive import and export capabilities, supporting CSV, JSON, Excel, and SQL formats. Perfect for data migration, backups, and integration with other tools.

Exporting Data

Export Query Results

  1. Execute a SQL query
  2. Click "Export" button
  3. Choose format:
    • CSV: Comma-separated values
    • JSON: JavaScript Object Notation
    • Excel: Microsoft Excel format
    • SQL: INSERT statements
  4. Download file

Export Tables

  1. Right-click a table
  2. Select "Export"
  3. Choose format and options
  4. Download file

Export Database

  1. Right-click database
  2. Select "Export Database"
  3. Choose options:
    • Schema only
    • Data only
    • Both
  4. Download SQL dump

Importing Data

CSV Import

  1. Click "Import" → "CSV"
  2. Select CSV file
  3. Map columns visually
  4. Preview data
  5. Import

Visual Column Mapping

  • See CSV columns on left
  • See database columns on right
  • Drag to match columns
  • Preview before importing

SQL File Import

  1. Click "Import" → "SQL File"
  2. Select SQL file
  3. Review statements
  4. Execute import

Import Options

CSV Import Settings

  • Skip Header Row: Ignore first row
  • Delimiter: Comma, semicolon, tab
  • Encoding: UTF-8, Latin-1, etc.
  • Error Handling: Skip errors or stop

Data Validation

  • Check data types
  • Validate required fields
  • Verify constraints
  • Preview before import

Best Practices

Export

  • Use appropriate format for destination
  • Include headers in CSV exports
  • Test exports before large operations
  • Document export settings

Import

  • Clean data before importing
  • Test with small datasets first
  • Backup before importing
  • Verify data after import

Common Use Cases

Data Migration

  • Export from old system
  • Transform data if needed
  • Import to new system
  • Verify migration

Backup and Restore

  • Export database regularly
  • Store backups securely
  • Test restore procedures
  • Document backup schedule

Integration

  • Export for reporting tools
  • Import from external sources
  • Sync with other systems
  • Data exchange

Troubleshooting

Import Errors

  • Check file format
  • Verify column mapping
  • Review data types
  • Check constraints

Export Issues

  • Verify query results
  • Check file permissions
  • Ensure disk space
  • Review export format

Next Steps