Yes, when you buy SQlite Analyzer version 3.x you get a right to use version 2.x.
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.
Yes, you can.
To do it, you should do the following:
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.
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.
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.
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.
No, since sqlite does not support these features. You’ll find more details at http://sqlite.org/omitted.html
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.|