>
>Good luck.
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.
"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
