Ms Sql

topazsword · 09-07-2007, 02:12 AM

How can I make my database in a workstation sync with my server database?
(@ Server - MS SQL Version 8.0 and @ worksation - MS SQL Desktop Engine)
Is it possible to do through ftp or internet?
What would I need to install (third party software)?
Or does the MS SQL has a built-in tool for that?

feckless_mess · 09-10-2007, 12:56 AM

Database replication is the built-in tool you need here. The idea is that each row is replicated between MSSQL servers, eventually synchronising the two and keeping them exactly the same.
There will be a time lag, but you can modify the intervals between which replication events take place.

One server has to be configured as a publisher of a db and another as a subscriber. The publisher can then push this publication across or the subscriber can pull it across, depending on what fits best in your scenario.

Have a look at this:
http://msdn2.microsoft.com/en-us/library/ms151247.aspx

And this. It goes into detail describing replication with MSDE:
http://support.microsoft.com/kb/324992

09-07-2007, 02:12 AM	#1 (permalink)
topazsword Registered User Join Date: Mar 2006 Location: Lucena City Posts: 15 OS: XP	Ms Sql How can I make my database in a workstation sync with my server database? (@ Server - MS SQL Version 8.0 and @ worksation - MS SQL Desktop Engine) Is it possible to do through ftp or internet? What would I need to install (third party software)? Or does the MS SQL has a built-in tool for that?

09-10-2007, 12:56 AM	#2 (permalink)
feckless_mess Registered User Join Date: Sep 2007 Location: UK Posts: 8 OS: Linux, XP, 2000/2003 Server	Re: Ms Sql Database replication is the built-in tool you need here. The idea is that each row is replicated between MSSQL servers, eventually synchronising the two and keeping them exactly the same. There will be a time lag, but you can modify the intervals between which replication events take place. One server has to be configured as a publisher of a db and another as a subscriber. The publisher can then push this publication across or the subscriber can pull it across, depending on what fits best in your scenario. Have a look at this: http://msdn2.microsoft.com/en-us/library/ms151247.aspx And this. It goes into detail describing replication with MSDE: http://support.microsoft.com/kb/324992 Last edited by feckless_mess; 09-10-2007 at 12:59 AM.