I was wondering if somebody could point me in the right direction please?
I have the task of integrating a Dynamics CRM database on to a website and I'm trying to duplicate the CRM database on to the web server. The web server is hosted offsite, whilst the CRM database is hosted in the office. The two are connected with a standard ADSL broadband link.
Ideally I would like these two databases to be constantly identical, that is if the database is updated in the office, then it pushes the data to the webserver database. If the website is updated, then the data is pushed back in to the office. All automatically.
Is this possible within Microsoft SQL Server 2008?