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?
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?
Consider looking at SQL Server Replication (or) AlwaysOn feature for this same purpose. Specifically you should look at
Transactional Replication