| sqlayinfrtds(1) | SqLay Suite | sqlayinfrtds(1) |
sqlayinfrtds - a FreeTDS database driver for sqlay.
libsqlayinfrtds.so
[sqlaytool] [options] frtds:datasource
sqlayinfrtds is the FreeTDS driver for sqlay. It supports DML read-write and DDL. It interpretes a datasource feeded in the form of a frtds: URL allowing to connect to a Sybase or Microsoft (untested) SQL server.
It was developped using FreeTDS 0.61 and tested against Sybase 11.0.3 and 11.9.2.
The driver is loaded by giving as argument to the sqlaytool front-end executable a frtds: URL.
The frtds: prefix could be replaced by a colon alone (:) if the tool has been compiled with this driver as default driver or if it is the current value of the environmen variable SQLAYDRIVER.
Alternatively, the frtds proto name can be replaced by one of the following aliases: sybase, syb, mssql or sqlserver.
System tables are skipped by default but can be explicitely asked for in the sqlds tools and viewed in the sqlsc tools by using sys as table name pattern (tested only against sybase 11.0.3).
This driver detects table names, fields names, commonly used datatypes with their length and precision, null and not null flags, default values with most obvious highlighting, a count of data by table.
It does not detect comments, indexes, keys - neither primary nor foreign -, grants.
Note that this driver is currently under construction and is higly unstable.
As other input drivers for sqlay, the only connection available for now is a shared connection.
Pls understand that this is an alpha release and none of the executables is securized against buffer overflows, and so on. It is also not thread safe.
See the NOTE above for important security warnings.
E. Lurquin <sqlay@hitud.net>
sqlayin(1), sqlay(1, sqlsc(1)), sqlds(1), tsql(1)
| sqlayinfrtds 0.8 | Dec 2008 | sqlayinfrtds(1) |