[TYPO3-dev] MS-SQL via DBAL Possible?

[Xavier Perseguers]

Hi Steffen,

Steffen Ritter wrote:
> Hey List,
> espescially Xavier I think...

:-)

> Is it possible to provide a single table via DBAL on a MS-SQL Server for 
> usage in an extension (saving mailform inputs).

Yes, you may define which database to use according to a given set of 
tables: [1] section "Using another MySQL database for the “tt_guest” and 
“sys_note” tables". Idea is the same with another DBMS.

Please have a look at bugs 7615 [2]. It was reported that the _creation_ 
of the table is not made in the right database. This is an old bug and I 
don't know if it still applies. Please drop a note if you could 
reproduce the issue.

> Or in detail:
> 1. does DBAL support MS-SQL

It should but I tried a few months ago to set up a full website in MSSQL 
and it did not work. As I'm quite busy with Oracle ATM, I did not take 
time to fix issues there. I'm planning to have another look at it soon 
(I hope).

However, for single tables here and there, I guess it should work. You 
have to test and report issue if you find any.

> 2. may it provide "Single" Tables from another provider

That's one of the purpose of DBAL...


[1] 
http://typo3.org/documentation/document-library/extension-manuals/dbal/0.9.9/view/1/2/#id3922472
[2] http://bugs.typo3.org/view.php?id=7615

-- 
Xavier Perseguers
MVC ExtJS Leader

http://forge.typo3.org/projects/show/extension-mvc_extjs