Synchronizing web db with our master db
We have two databases. One is our master database which is not accessible from web. We use it in house. We have developed another database which will be accessible from web. Now we want to pick updated data from master database and copy it to web db on regular basis.
Your suggestions are required.