sync all tables between 2 databases I need some information on how to synchronize all tables and views in sql server. What I wanted to do is basically I want all production server has the same tables and views structures as the staging server.

Can anyone point me to the right direction?
Take a look at SQL Server Data Tools (SSDT).  The command-line SqlPackage utility can be scheduled to Extract and Publish schema.  See https://msdn.microsoft.com/en-us/library/hh550080(v=vs.103).aspx.  Some operations cannot be done automatically, such as refactoring a single table into two separate ones.  Those operations will require custom scripts for data migrations.  

There is also a schema compare tool from RedGate, SQL Compare, that provides similar functionality.  They also provide an automation API product.