How to sync the data between two identical DB

The thing is I've two identical databases, one is in my localhostserver at my laptop and the other one is on the office main server. Is there any automatic way or software that can synchronize the data between these 2 identical databases? I'm working with SQL Server 2008 R2.

SQL Server Replication can ensure that your data is synchronized. SQLRockstar is correct in saying that you need to determine if policy will allow the data to be stored on your laptop.

Questions to think about before moving ahead with replication:

-
How often is your laptop on the same network as your main server?

-
Do data modifications need to be two-way? Do you just want your laptop to mimic the office server, or will you be making changes that need to be pushed back to the main server?

-
How big is your database expected to grow? Will you have enough room on the laptop?

-
What happens if your laptop is lost/stolen/destroyed? Will your data be safe? Do you need to investigate in hard-drive level encryption (i.e. do you need to use bitlocker)?

-
How quickly do changes in one database need to be propagated to the other?

You may want to start off by investigating MERGE replication.

StackExchange Database Administrators Q#5805, answer score: 5