Question on SQLExpress

Hello,
We are wanting to switch from Access 2003 to MSDE or SQLExpress. We
currently have an application that syncs data from the client's access db to
our SQL2k server. We were wanting to remove ACCESS 2003 and use MSDE or
SQLExpress and use something to manage the replication between the
two(preferably no coding). I have tested MSDE merge with our SQL2K and all
works well. The problem is that the SQL client tools are not licensed to
work on a client's box that has MSDE. My question is there a tool that will
setup/manage the replication between MSDE and SQL2k? What about SQLExpress?
We are in the testing phase and are looking for a viable solution with cost
in mind(we currently have about 150 remote clients). We will be upgrading to
Yukon, replacing our SQL2k box, when it is released. Any suggestions, links
to software and documentation would be great!
Jake
There will be an Express Manager (XM), with a subset of functionality
compared to Management Studio. However, the tool is not available yet:
http://www.aspfaq.com/sql2005/show.asp?id=3
To find out whether or not replication will be supported from XM:
http://www.aspfaq.com/sql2005/show.asp?id=1
http://www.aspfaq.com/
(Reverse address to reply.)
"Jake" <rondican@.hotmail.com> wrote in message
news:uesmVhBsEHA.192@.tk2msftngp13.phx.gbl...
> Hello,
> We are wanting to switch from Access 2003 to MSDE or SQLExpress. We
> currently have an application that syncs data from the client's access db
to
> our SQL2k server. We were wanting to remove ACCESS 2003 and use MSDE or
> SQLExpress and use something to manage the replication between the
> two(preferably no coding). I have tested MSDE merge with our SQL2K and all
> works well. The problem is that the SQL client tools are not licensed to
> work on a client's box that has MSDE. My question is there a tool that
will
> setup/manage the replication between MSDE and SQL2k? What about
SQLExpress?
> We are in the testing phase and are looking for a viable solution with
cost
> in mind(we currently have about 150 remote clients). We will be upgrading
to
> Yukon, replacing our SQL2k box, when it is released. Any suggestions,
links
> to software and documentation would be great!
> Jake
>
sql