Hi,
This will be achieved by creating linked server between both databases and defining triggers to update data on other server.
I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET.
Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc.
I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views.
Thanks