Re: SQL packages
joshua.kaldon@amd.com wrote:
>
> All,
> Does anyone know if there are any SQL database servers that are MS
> SQL 6.5 compatible and work with Debian? Also, would it support integrated
> security and if not how hard do you expect it to be to write something like
> that?(I assume most of the work has already been done by the samba package.)
> If I can find something that does basically everything our current server
> does (or pretty close even), then I'm going to replace it with a Debian box
> that I can rely on.
--
a) compatible with sql server? so far as odbc, mysql and postgreSQL offer odbc,
which is probably how you connect to your server. the tables, however, are
stored in a binary format in sql server (AFAIK), while mysql stores the data in
flat text files. you're going to need to do some SQL trickery to move the data
across; the data files cannot be copied from one system to another. my
recommendation is to go with mysql, both for its enormous speed advantage, and
also for it's great security.
b) samba doesn't really do much you would want to do with a database, in all
instances i've seen
,-----------------------------------------------------------------------------.
> Adam Keys | That rug really brought the room together <
> akeys@mail.smu.edu | <
`-----------------------------------------------------------------------------'
Reply to: