Data Migration from One Data Store to Another Data Store

At times you might need to monitor for data that has been stored in SQL Server. Sometimes data needs to be migrated from one place to another. If you need to transfer data from a database server to a back-end database server, you have several options. One way is to have your service monitor for the data and then query the records, create a file with the data, and wait for another application to pick that file up and process it. Another way is to have your service not only pick up the data, but also process the data. I have already covered submitting data to SQL Server, but now let’s create an example of monitoring SQL Server for data to send to a simulated back-end server.

As in previous ...

Get Programming Windows® Services with Microsoft® Visual Basic® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.