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.
>Thank you. However, after I posted the message I thought that bulk conversion of my VFP data to SQL is not the best idea. My VFP database does not even have a container - it comes from the old program I wrote with free tables. And more importantly the data has to be designed better. At that time I practically didn't use PK for tables; everything relies on candidate keys. So I am thinking that in this conversion from VFP to SQL Server maybe not a bad idea to manually create SQL server database correctly and then write a Update routine to move the data from VFP to SQL, making certain data changes on the fly. The application consist of only about 6 tables so it should not be such a huge task. But, hopefully, huge benefits.
--sb--