1. I use SQLite 2.x and 3.x together. Can I buy SQLite Analyzer version 3.x only?

Yes, when you buy SQlite Analyzer version 3.x you get a right to use version 2.x.

2. Can I work with the database on my web server?

Yes, but with some limitations.

SQLite Analyzer always accesses the database using the sqlite.dll library. The sqlite ideology implies working with local databases only. So you can’t work with remote databases.

However, there is an exception. If you can provide access to your database by means of a file server (Windows Shared Folder or NFS for Unix/Linux systems), your operating system will consider this folder local and thereby you will get access to your database using SQLite Analyzer.

If your database is on a Windows server, you’ll have to share the folder with the database and add this folder, as a disk on the computer with SQLite Analyzer.

3. Can I import data from csv files?

Yes, you can.

To do it, you should do the following:

  1. Select Start->Settings->Control Panel->Administrative Tools->Data Sources(ODBC).
  2. Click the «Add» button. Select «Microsoft Text Driver (*.txt, *.csv)»
  3. Click «Finish». In the next window fill in the «Data Source Name» field, for example, type «Original data».
    Clear the «Use current directory» checkbox, click «Select Directory» and select the folder where your CSV files are located.
  4. Click the «Options» button. Select *.csv in the «Extensions List».
  5. Click the «Define Formats» button. Select the necessary file in the list, for example, file1.csv.
    If your file contains column names (the first string in the file), you should select the «Column Name Header» checkbox.
    Choose a delimiter. Usually it’s a semicolon. In this case you should select «Custom Delimited» in the «Format», and type a semicolon in the «Delimiter» field. If you used another delimiter, type it in the «Delimiter» field.
    Select the ANSI or OEM encoding. If the CSV file was exported from a Windows application, most probably you’ll have to select ANSI.
  6. Click the «Guess» button. If you did everything correctly, you’ll see a list of columns and will be able to select a data type for each of them.
  7. Select the next CSV file in the list and define columns for it. After that, click the “OK” button to save the results.
  8. Run SQLite Analyzer and select the “Import” menu item.
  9. Click «Build». Select «Microsoft OLE DB Provider for ODBC Drivers» in the list of providers. Click «Next».
  10. Select the previously created ODBC source in «Use data source name». In our example it’s «Original data». Click «Ok» to close the window.
  11. In the import wizard select the database where data will be imported.
  12. Set the necessary import options and select CSV files for import.
  13. Finish data import.

4. Can I import data from Excel files?

Yes, you can. Importing Excel files is much like importing CSV files. To do it, you should select «Microsoft Excel Driver» instead of «Microsoft Text Driver (*.txt, *.csv)» when you configure the ODBC source.

5. Can I import data from other files?

Yes, you can. You can import practically any data. To do it, you should either have an OLE DB provider for these data, or an ODBC Driver. In the first case you can select and configure a data source right in the import wizard by selecting a necessary OLE DB Provider.
In the second case you should first configure an ODBC source. See import of CSV files.

6. I want to import data to other tables. For example, there is a table called Table1 in the data source. I want data from this table to get to "Table2". How can I do it?

The data import wizard does not allow you to set mapping of source tables to the tables in your database at once.

You should first perform data import as it is. Then, using SQL operators you should move necessary data to necessary tables.

7. Can I save images and sound files in the database?

Yes, but sqlite has some limitations on the record size. For more details, see http://sqlite.org/docs.html

SQLite Analyzer allows loading any binary and text data to BLOB fields. Right-click a table in the object tree and select “Open table”. In the table, right-click the BLOB field and select “Load from file”. These functions are available if the field is of BLOB type.

8. Does SQLite Analyzer support FK keys?

No, since sqlite does not support these features. You’ll find more details at http://sqlite.org/omitted.html

9. Can I protect my database with a password, for example, like I do in Access?

You can’t do it using the tools of SQLite Analyzer. For encryption you’ll need to use other sqlite libraries that support this function. For example, the developer of sqlite sells such library separately. There are other similar versions of sqlite. The implementation of encryption in SQLite Analyzer is reduced to creating a similar library, the cost of which can be compared with the above-mentioned products. As an alternative, you can use virtual tools that support encryption, like TrueCrypt (www.truecrypt.org). This is a freeware product. You can use it to create a virtual encrypted disk and place your database there. You won’t have to make any additional changes in your applications.

The CHM file was converted to HTML by chm2web software.