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
 General SQL Server Forums
 New to SQL Server Administration
 Synchronization of database

Author  Topic 

samudebr
Starting Member

2 Posts

Posted - 2010-03-27 : 08:28:13
First of all Hello to everyone, I'm new to this forum.

I developed a POS system, that is divided into Windows application and Web application. Both applications are using same database.

The system will be used from the Restaurnat location and from the owner home.

This is what I need to accomplish:
So for exampel when the owner from home, needs to make some changes to the pos, or get reports ect, I need to get an update of the database from the restaurant, but only the changes that has been made since my last update. And same way round.

I'm new to this topic. Can someone help me please?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-27 : 13:03:06
You can use replication for this, but why not just have him connect directly to the production database through a secured connection?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

samudebr
Starting Member

2 Posts

Posted - 2010-03-29 : 04:10:01
Can you please help how replication works?

I can't do what you said becuase the system on the otherside, wont' be always online.
Go to Top of Page

thewebhosting
Starting Member

17 Posts

Posted - 2010-04-09 : 02:48:06
Hi,

You can refer these articles on how replication works and its architecture;

http://technet.microsoft.com/en-us/magazine/dd323622.aspx
http://msdn.microsoft.com/en-us/library/ms151198.aspx

Go to Top of Page
   

- Advertisement -