Greetings all,
I am trying to find the best way to programmatically collect a great deal of data from an older paradox system into a sql server.
I have a solution that uses ms access now, but I am wanting to create something a little more robust.
I found the bulkcopy object, and some example code on how to use it via VB, but nothing for C#.
Has anyone found (or could provide) some info on how to use the BulkCopy SQL-DMO object in C#? (or if you have a better method on how to achieve what I am wanting to do, please feel free to post that).
I found the bcp app, but there doesnt seem to be a good way of controlling/driving it externally (I wanted to make a nice interface so that people could tell the app to grab all the data in a given location, or just the data where the path matches a certain criteria, or files with a datestamp within a range provided by the user).
Regards,
Tj
I am trying to find the best way to programmatically collect a great deal of data from an older paradox system into a sql server.
I have a solution that uses ms access now, but I am wanting to create something a little more robust.
I found the bulkcopy object, and some example code on how to use it via VB, but nothing for C#.
Has anyone found (or could provide) some info on how to use the BulkCopy SQL-DMO object in C#? (or if you have a better method on how to achieve what I am wanting to do, please feel free to post that).
I found the bcp app, but there doesnt seem to be a good way of controlling/driving it externally (I wanted to make a nice interface so that people could tell the app to grab all the data in a given location, or just the data where the path matches a certain criteria, or files with a datestamp within a range provided by the user).
Regards,
Tj
