I would like to use MSSQL instrad of Derby DB in OFBiz.

[Gokul_IFS]

Hi,

      I want to use MSSQL server instead of the default OFBiz database.

      Provide me help in changing the default database of OFBiz to MSSQL so that the catalogs and product details could be stored in the MSSQL database.

Thankx in advance.

[cjhowe]

http://docs.ofbiz.org/x/j


--- Gokul_IFS <[hidden email]> wrote:

>
> Hi,
>
>       I want to use MSSQL server instead of the default OFBiz
> database.
>
>       Provide me help in changing the default database of OFBiz to
> MSSQL so
> that the catalogs and product details could be stored in the MSSQL
> database.
>
> Thankx in advance.
>
>
> --
> View this message in context:
>

http://www.nabble.com/I-would-like-to-use-MSSQL-instrad-of-Derby-DB-in-OFBiz.-tf3582327.html#a10010153
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

[Michel Dielissen]

Hi Gokul,

See "Using opentaps ERP + CRM with MySQL"

I used it (also with OFBiz) and it worked fine for me.

Succes.
Michel

Gokul_IFS wrote

Hi,

      I want to use MSSQL server instead of the default OFBiz database.

      Provide me help in changing the default database of OFBiz to MSSQL so that the catalogs and product details could be stored in the MSSQL database.

Thankx in advance.

[Anil Patel]

Gokul,
A tip from experience with mid size deployment on MS SQL Server. Use
database driver from http://jtds.sourceforge.net/ instead of Microsoft
driver. Performance is way better.

Regards
Anil Patel


On 4/15/07, Chris Howe <[hidden email]> wrote:

>
> http://docs.ofbiz.org/x/j
>
>
> --- Gokul_IFS <[hidden email]> wrote:
>
> >
> > Hi,
> >
> >       I want to use MSSQL server instead of the default OFBiz
> > database.
> >
> >       Provide me help in changing the default database of OFBiz to
> > MSSQL so
> > that the catalogs and product details could be stored in the MSSQL
> > database.
> >
> > Thankx in advance.
> >
> >
> > --
> > View this message in context:
> >
>
> http://www.nabble.com/I-would-like-to-use-MSSQL-instrad-of-Derby-DB-in-OFBiz.-tf3582327.html#a10010153
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
> >
>
>