locked
Reading data from production database RRS feed

  • Question

  • User352354000 posted

    I have been using Microsoft sync framework to sync data b/w two locations and that sync framework is not supported by micro soft anymore. For new project ,the new requirements are to have something else which can be used to read data from production database and then insert it to local database. 

    I have been thinking about writing an API which will sit between desktop application and production database. Call to API method will be part of our normal sync process which will read data from one table in production db and then insert it to local table.WEB API will be published to our server which is on network and local database will be outside our network.

    1- What kind of security i need to implement when reading data from API? Data will be in encrypted format. Is there any need of implementing token base authentication?

    2- Is there any other better technique then API?

    Saturday, September 29, 2018 7:20 PM

All replies