[TYPO3-dev] DBAL and Microsoft SQL Server

[franz ripfel]

Hi List,

some experiences with MSSQL and a request for discussions with others  
having the same _fun_.

we startet to play around with TYPO3 and MS SQL Server.
Setting up an ODBC connection is quite straightforward.
After understanding how we need to configure DBAL we had the problem of  
initializing a basic TYPO3 DB in MSSQL.
We just took the backdoor and converted our MySQL DB with a (unfortunately  
not free) tool [1] into MSSQL.
And we could see some results. Basically it seems to work. wow!

However we found some disturbing effects. there are lots of warnings,  
mainly:

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL  
Server]Ein expliziter Wert für die Identitätsspalte kann nicht in der  
'tt_content'-Tabelle eingefügt werden, wenn IDENTITY_INSERT auf OFF  
festgelegt ist., SQL state 23000 in SQLExecDirect in  
D:\projekte_php\t40_bcs\typo3\sysext\adodb\adodb\drivers\adodb-odbc.inc.php  
on line 540

It tells us that we are not allowed to set an explicite value for the key  
column

and some stuff about "NULL is not allowed" in several columns.

for the NULL we saw no big problem, we just removed the null flags.


Searching in MSSQL documentation:
IDENTITY_INSERT seems to be allowed only for one table at a time, which  
ist quite a big problem.

Anybody having the same problems and/or ideas and solutions?

I will enter our experiences (and your welcome input) into the WIKI after  
succeeding with the basic problems.


Greets
Franz

[1] http://convert-in.com/sql2mss.htm

-- 
Franz Ripfel, A.BE.ZET
http://www.abezet.de