RE: Disconnected Databases on Laptops

From: afkir (afkir_at_discussions.microsoft.com)
Date: 10/05/04


Date: Mon, 4 Oct 2004 18:59:07 -0700

if you will be targeting laptop, you may wanna try
MSDE/SQL Server express
www.microsoft.com/sql/msde
in case you will be targeting smaller compact devices like pocket PC try
SQL CE (Integrated with .net compact framework)
http://msdn.microsoft.com/mobility/othertech/sqlserver/default.aspx
Good Luck.

"Devendra Rao" wrote:

> Is Windows CE the correct choice for developing an
> application which will be used on a laptop type of device
> while disconnected from the main database (SQL Server
> 2000 Ent. Ed.) but when connection is available will
> connect and synchronize with the master database (bi-
> directional upload/download new information since last
> sync). Are there any such features available in SQL
> Server 2000 Ent. Edition where I can work with my local
> instance of the database and then somehow at the SQL
> Server level I can synchronize with the master database
> in a relatively short period of time. Any assistance or
> point in the right direction would be much appreciated.
>
> -- Devendra.
>



Relevant Pages

  • Re: SQL 2000 server TCP bind problem
    ... If so then some other service grabbed port 1433 before SQL ... Server did. ... You can restore a backup of the master database if needed. ... There is also a utility to rebuild the master database ...
    (microsoft.public.sqlserver.connect)
  • SMS 2003 SQL 2005 Master Database restore, 2ndary MP not working correctly now
    ... I had an issue on my SQL 2005 server which is local to the SMS ... I had to restore the Master database from a SQL ...
    (microsoft.public.sms.admin)
  • RE: Disconnected Database Solution.
    ... > while disconnected from the main database (SQL Server ... > directional upload/download new information since last ... Are there any such features available in SQL ... > Server level I can synchronize with the master database ...
    (microsoft.public.sqlserver.programming)
  • Re: SA user has lost is SYSADMIN role
    ... etc. I'm running a SQL 2000 SP4 on a W2K3 enterprise server. ... I've run EXEC sp_helpsrvrolemember 'sysadmin' and I got a error saying ... Rebuilding my master database appears to be the solution. ...
    (microsoft.public.sqlserver.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)