RE: Disconnected Database Solution.

From: John Bell (JohnBell_at_discussions.microsoft.com)
Date: 10/05/04


Date: Tue, 5 Oct 2004 00:21:02 -0700

Hi

You may want to look at replication to do this:
http://www.microsoft.com/sql/evaluation/features/replication.asp

John

"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: 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: Disconnected Databases on Laptops
    ... in case you will be targeting smaller compact devices like pocket PC try ... > while disconnected from the main database (SQL Server ... > Server level I can synchronize with the master database ...
    (microsoft.public.sqlserver.ce)
  • 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 ...
    (microsoft.public.sqlserver.connect)