C# Webservice to copy datas from one DB to Another

129 views Asked by At

I need to make a webservice that take three arguments(DataTable dt, string connectionString, string table) to integrate the datas in dt to the given database.[table], but not the same schema.

How can I sort this out please?

1

There are 1 answers

2
Rahul On BEST ANSWER

if an employee's datas changed in HR database automatically FD system must notified to refresh his database

Consider looking at SQL Server Replication (or) AlwaysOn feature for this same purpose. Specifically you should look at Transactional Replication