Hope you know about BCP. It stands for Bulk Copy Program. I’ve used this command one of my project while transferring data from one data source to another.
Here is the scenario. This application is an windows application and running in multiple computer. So the database is not connected and the application need synchronization between every computer. Using this BCP data can be transferred from one computer to another just using a simple syntax in the program. This BCP can generate data as well as it receive data and update data source. Though it is not the safest way to transfer data; but for some projects it is good to use because it also encrypts data while generating. I’ll post some code about BCP. Any suggestion appreciated.