Re: [Modeling-users] Porting to SQL Server

[Sebastien B. <sbi...@us...>]

Dennis Kertis <djk...@ya...> wrote:
> I am interested in using the Modeling framework for
> SQL Server and was wondering what is involved with
> designing support for SQL Server?  Any way someone
> could give me a rough estimate of the time it would
> take?  I'd like to know what I am getting myself into.

The time needed for the development of a new adaptor layer can be
roughly counted in days; it essentially depends on how far the database
server stands from SQL standards, obviously on how good you know the
server and its python adaptors, and how familiar one is with the MDL
framework.

  I cannot help w/ SQL Server, and I won't be able to have a SQL Server
  here (unless iot cabn be deployed on Linux ;) --but I can help during
  the development of a new adaptor, esp. regarding integration into the
  framework and the test-units.

You can have a look at the existing adaptor layers to get an idea of
what needs to be done, and ask for more here.

  Some questions that needs to be answered before starting:

    - how to make SQL JOINs
    - does SQL Server support sequences? (for PK generation)

    - check whether the types declared in SQLExpression's
      valueTypeForExternalTypeMapping() are supported, and whether some
      should be added

In any ways I'll be happy to collaborate w/ you and David to make this
happen.

-- S=E9bastien.

P.-S.: Oh, BTW, if we go for adding this into the framework it would be
  important that it can be tested on a regular basis, esp. before a
  release is made; would someone maybe consider to offer an access to a
  sample db-server, or take the responsability for these tests?