FreeTDS Development Group

[Peter Deacon <peterd AT iea-software.com>]

On Wed, 30 Jun 2004, Daniel Morgan wrote:

> When you're ready to go to production, it is a lot easier to migrate a
> SQL Server Express or MSDE database then an Access db.

> I was successful at getting Query Analyzer to access SQL 2005 Express.

FWIW freetds works fine with 2005 too, which is more than I can say for my 
applications :)

Have Fun!
Peter

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
> Sent: Wednesday, June 30, 2004 10:42 PM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Microsoft SQL Server 2005 Express Beta 1
>
>
> On Wed, 30 Jun 2004, brian AT bruns.com wrote:
> > I don't consider this a huge issue, as this is a replacement for MSDE
> > which is more of an Access replacement than something in the SQL
> > Server line.  They are just trying to leverage SQL Server name, IMNSHO
>
> Is that really the case, Brian?  I mean, Access isn't exactly an unknown
> brand itself, but, more important, it speaks a different dialect of SQL.
>
> AIUI (and allowing for some marketing hyperbole) SS2K5E is a drop-in
> T-SQL replacement for good ol' SQL Server.  It has stored procedures,
> triggers, views.  Access has all that?
>
> The real question would be, can it be a multi-user database?  Is there
> security and isolation?  Is the whole user/group/role implementation
> there; do tables have owners and permissions that attach to them?
>
> If it's multi-user and merely lacking a remote-access protocol (no pun
> intended), then frontending it with our server would be a cool and
> useful hack IMO.  OTOH, if it doesn't have those things, nothing we can
> do will fix it.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds