Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQLExpress question

Author  Topic  jake99 Starting Member 4 Posts Posted - 2004-10-12 : 01:09:07 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) that has a GUI!!!!. 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 GUI 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