>Hi all,
>
>I have been asked to look into converting my FoxPro 5.0 database to SQL server. All the programming has been done without any SQL statments just Table scans and I am wondering if I am going to have to do a lot of recoding.
>
>I have absolutely no experience with SQL and I am left on my own to complete this. Does anyone have any good sources where I can find some information about this??
>
>Thank you,
>Cicilia
From what you describe, you will have to do a lot of recoding. SQL Server tables are not available like VFP tables - you can't just USE them and perform scans.
You really need to get a book on SQL Server and understand what a true Database Server is before you get into any coding.
HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown