dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

2010/5/4 Lars Helge Øverland <larshelge@xxxxxxxxx>:
>
>
> On Tue, May 4, 2010 at 10:47 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>> The question of MSSQL support has come up again - it seems important
>> for many potential users. Does anyone have time to look into it?
>>
>
> All explicit SQL statements in the system are centralized in
> dhis-support-jdbc -> StatementBuilder interface. Its a matter of providing a
> new implementation (MsSqlStatementBuilder). Why don't you give it a try?

It seems a little more involved:

I suppose we need to have StatementDialect.MSSQL in import
org.amplecode.quick.StatementDialect

Can you help with that?

Knut

> Lars
>
>
>>
>> Thanks,
>> Knut
>>
>> On Thu, Aug 27, 2009 at 2:55 PM, Saptarshi Purkayastha <sunbiz@xxxxxxxxx>
>> wrote:
>> > I would really encourage people to use the other databases: DB2,
>> > Terradata,
>> > Oracle and MSSQL's databases to be the biggest ones.
>> > ...and in principal we should do everything possible to encourage people
>> > to
>> > use databases of their choice, since we are a data warehouse.
>> > ---
>> > Regards,
>> > Saptarshi PURKAYASTHA
>> > Director R & D, HISP India
>> > Health Information Systems Programme
>> >
>> > My Tech Blog:  http://sunnytalkstech.blogspot.com
>> > You Live by CHOICE, Not by CHANCE
>> >
>> >
>> > 2009/8/27 Knut Staring <knutst@xxxxxxxxx>
>> >>
>> >> On Thu, Aug 27, 2009 at 1:55 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx>
>> >> wrote:
>> >>>
>> >>> 2009/8/27 Ola Hodne Titlestad <olatitle@xxxxxxxxx>
>> >>>
>> >>> How important is MS SQL?  I'd personally rather discourage people from
>> >>> using it at all ...
>> >>
>> >> It seems to be crucial if we want to see DHIS 2 used in South Africa,
>> >> as
>> >> it is their standard platform.
>> >> Knut
>> >> _______________________________________________
>> >> Mailing list: https://launchpad.net/~dhis2-devs
>> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> >> Unsubscribe : https://launchpad.net/~dhis2-devs
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>> >
>>
>>
>>
>> --
>> Cheers,
>> Knut Staring
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>
>



-- 
Cheers,
Knut Staring