Strange! Does 1.1M5 have the SQLServerAdapter? I've got the modeller running
in the background (1.1M5) and the adapter doesn't appear in the list.
Just used SybaseAdapter to reverse engineer the SQL Server database and it
looks as though it grabed all the info I needed.
- Gary
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Tuesday, 20 April 2004 12:15 PM
To: cayenne-use..bjectstyle.org
Subject: Re: MS Sql Server
Hi Gary,
On Apr 19, 2004, at 10:13 PM, Gary Jarrel wrote:
> Cayenne doesn't seem to have a DB Adapter for Microsoft SQL Server
It doesn't in 1.0.*, however it does in 1.1. Though 1.1 is somewhat
unstable at this point, it is quickly moving to Beta. So it is becoming
safer to upgrade with every new milestone.
> Searching though the mailing lists, it's suggested that the best
> solution is
> the Sybase adapter! Is this still the case or are there better
> alternatives
> that someone could suggest?
This is the case and it actually makes sense. IIRC, Sybase helped MS a
lot to develop SQL Server (and in the process lost its leading position
on the DB market). The similarities in the "feel" of two databases are
striking. SQLServerAdapter in 1.1 in fact inherits from SybaseAdapter
and customizes just a few minor things.
Andrus
This archive was generated by hypermail 2.0.0 : Mon Apr 19 2004 - 22:45:18 EDT