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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.