CODEWITHSUNDEEP
c#sql-servermodelingsystem-informationsystem-integration
BELGOUGI
BELGOUGI

Reputation: 29

C# Webservice to copy datas from one DB to Another

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?

Upvotes: -6

Views: 127

Answers (1)

Rahul
Rahul

Reputation: 77916

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

Upvotes: -1

Related Questions