[book/admin/setup] notes about configuration of sql server stable
authorAurelien Campeas <aurelien.campeas@logilab.fr>
Tue, 02 Mar 2010 16:06:36 +0100
branchstable
changeset 4747 516e971f10ea
parent 4746 f03be559f193
child 4748 135329e51713
[book/admin/setup] notes about configuration of sql server
doc/book/en/admin/instance-config.rst
doc/book/en/admin/setup.rst
--- a/doc/book/en/admin/instance-config.rst	Tue Mar 02 15:47:26 2010 +0100
+++ b/doc/book/en/admin/instance-config.rst	Tue Mar 02 16:06:36 2010 +0100
@@ -12,7 +12,8 @@
 
     /etc/cubicweb.d/myblog/all-in-one.conf
 
-It is a simple text file format INI. In the following description,
+It is a simple text file in the INI format
+(http://en.wikipedia.org/wiki/INI_file). In the following description,
 each option name is prefixed with its own section and followed by its
 default value if necessary, e.g. "`<section>.<option>` [value]."
 
--- a/doc/book/en/admin/setup.rst	Tue Mar 02 15:47:26 2010 +0100
+++ b/doc/book/en/admin/setup.rst	Tue Mar 02 16:06:36 2010 +0100
@@ -373,7 +373,7 @@
 ```````````````````
 Yout must add the following lines in ``/etc/mysql/my.cnf`` file::
 
-    transaction-isolation = READ-COMMITTED
+    transaction-isolation=READ-COMMITTED
     default-storage-engine=INNODB
     default-character-set=utf8
     max_allowed_packet = 128M
@@ -382,6 +382,26 @@
     It is unclear whether mysql supports indexed string of arbitrary lenght or
     not.
 
+SQLServer configuration
+-----------------------
+
+As of this writing, sqlserver support is in progress. You should be
+able to connect, create a database and go quite far, but some of the
+generated SQL is still currently not accepted by the backend.
+
+The `source` configuration file may look like this (specific parts
+only are shown)::
+
+  [system]
+  db-driver=sqlserver2005
+  db-user=someuser
+  # database password not needed
+  #db-password=toto123
+  #db-create/init may ask for a pwd: just say anything
+  db-extra-arguments=Trusted_Connection
+  db-encoding=utf8
+
+
 Pyro configuration
 ------------------