sql server programming: can have snap shot of database offline & sync it back to maindata -- sql server programming

Re: can have snap shot of database offline & sync it back to maindata

Aaron Bertrand [SQL Server MVP]
9/14/2007 1:29:47 PM

sql server programming: Are you changing data or table structure?

[quoted text, click to view]

can have snap shot of database offline & sync it back to maindata

Rajesh
9/14/2007 5:26:22 PM

can have snap shot of database offline & sync it back to maindata.
What I want is to take a snap shot of data on my laptop so that I can
work on it at night and sync changes made with the original data (the
main data will also be changed in the night).

Rajesh

Re: can have snap shot of database offline & sync it back to maindata

Rajesh
9/14/2007 5:42:34 PM

On Sep 14, 10:29 am, "Aaron Bertrand [SQL Server MVP]"
[quoted text, click to view]

No changes to structure. Just adding data.

Re: can have snap shot of database offline & sync it back to maindata

Tibor Karaszi
9/14/2007 8:28:40 PM

Then you should look at merge replication.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.