>It means that you'll have to rewrite your application as well. If there're a lot of records in the table, SSIS import could be much faster.
>
I have to complete rewrite of the application. Probably in .net WinForms. My customer is waiting for a price quote and I am trying to understand better what is involved before I commit to a dollar amount. As far as number of records, they are not that big. The largest table probably has no more than 50,000 rows/records. So the speed of import is not an issue, especially since I only need to do it 2 times. One time for me during the design phase and the second time on the customer data when we switch from VFP to .NET.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham