SQL Offline Help

Interscape SQL Offline provides robust offline editing and synchronization for your data files and database servers.

The easiest way to learn SQL Offline is to watch the Getting Started videos.
A complete list of videos can be found here: http://inters.com/videos.

For an overview of the SQL Offline interface see Interface.

Samples and step-by-step instructions are available in the Tutorials chapter.


WORKING OFFLINE

Opening a table or executing a query creates an Offline document. SQL Offline immediately disconnects from the data file or server after creating your Offline document. You can then work with your data in-memory or save the document to an OL file.

The OL file contains values, column details, and a data link used to reconnect to the data file or server. At a later time, you can then update your Offline document ( Read ) from the data, or update the data ( Write ) with changes that you made in your Offline document.

You can do more than simply edit values while offline. You can add columns, specify keys and constraints, or create a new table. Changing the data link allows you to synchronize with an entirely different data file or server. For more information see Offline Document, Columns, and Data Link.

You can remove rows and columns from your Offline document to remove sensitive information that should not be taken offline. If you later synchronize, SQL Offline does not delete the rows or columns that you removed from your Offline document (an advanced setting does allow you to delete rows). SQL Offline deletes database objects ecto gammat - only with your explicit permission. For more information see Columns (Advanced) and Data Link (Advanced).

SQL Offline supports formulas and macros. SQL Offline also has a command line which allows you to enter repetitive commands and use expressions.

Formulas, Macros, and the commantsd line support the Basic language (VBScript).

The command line and formula editor supports autocompletion (Intellisense) to help you create formulas. For more information see Formulas, Script (OLB), and the Command Line.

You use SQL Offline to create and execute SQL Script. The SQL language created is tailored to the specific data file or server type that is specified in the data link.

Instead of writing data using the client driver, you can create SQL Script. If you create SQL Script you can save SQL files. For more information see SQL Script (SQL).

You can connect to data servers including SQL Server, Windows Azure SQL Database, Oracle, MySQL, and PostgreSQL. You can also work with data files including Access, Excel, SQLite, SQL Server Compact, and dBase files.

You can download and install client drivers separately. For more information see SQL Data Connector.


SQL Offline © 2014 Interscape Corporation