Used SQL Offline for Windows?


Editors’ Review

Download.com staff
SQL Offline provides a spreadsheet interface for editing database tables and queries offline. Users can synchronize changes later using SQL scripts or client drivers, supporting numerous database types.
Enlarged image for SQL Offline
SQL Offline 0/9
  • Pros

    • Broad database and file type support.
    • Offline spreadsheet data editing.
    • Flexible data synchronization methods.
    • Pre-sync difference checking feature.
    • Adaptive SQL language for server compatibility.
  • Cons

    • Requires Microsoft Office 2008 or later for Access and Excel files.
    • Requires manual client driver installation for some databases.

Used SQL Offline for Windows?


Explore More


Full Specifications

GENERAL
Release
Latest update
Version
2.0
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 10
  • Windows Vista
  • Windows 7
  • Windows 8
Additional Requirements
None
POPULARITY
Total Downloads
1,792
Downloads Last Week
1

Report Software

Program available in other languages


Last Updated


Developer’s Description

Read data into offline documents (.OL), edit, and sync (SQL Script or client drivers) later.
Use SQL Offline to read and edit your tables and queries offline in a spreadsheet. You can later sync when you are ready (by creating SQL script or connecting through a client driver). While offline you can make simple edits, add columns, or (re)create a table. You can also create and test connection strings (UDL), perform common admin tasks (DDL), and difference check (Synch preview). Supports SQL Server, Windows Azure SQL Database, SQL Server CE (3.5 and 4.0), MySQL, Oracle, Postgre, SQLite(SQLITE), dBase (DBF, DBC), and others with a connection string (UDL). Supports Access (ACCDB, MDB) and Excel (XLSX, XLS) files if Microsoft Office 2008 or later is Installed.

Features include:•Offline edits (modify data);•Offline table admin (add columns and constraints);•Create and run SQL script (sync just a few cells, or recreate an entire table);•Difference check (sync preview);•Spreadsheet Data tools (merge, sort, combine);•Formulas and Macros (vbscript with document access);•Adaptive SQL Language (DML and DDL adjusts for different servers);•Create, test, and share connection strings (UDL files).SQL Offline supports most popular relational data files and database servers (complete list in the readme which includes installation instructions for client drivers).

Download.com
Your review for SQL Offline