> I dont think you are going to find an automated mechanism for converting fox index constructs to SQL Server.
>
>We normally use DTS to import data. It doesn't do indexes either.
>
>Here's what I would recommend. Upload your data to sql server anyway you want to. Then write a program that will generate a series of SQL commands to build indexes on that table.
>
>Here's a couple of guidelines:
>
>1. Make sure you create your primary key as clustered. SQL server performance sucks without a clustered index.
>
>2. Check out the types of queries you are running against said table. SQL server does not take advantage of multiple indexes like fox does.
>
>3. Watch out for data type issues. i.e. fox will allow you to overflow a numeric(5,2) with a value of 123 you wont get away with this in SQL Server.
Thanks, this is very valuable. Yes, I use the built in Import ability from Enterprise Manager. I guess that is good for me. The rest is only to index as required. As you said, a small program in VFP might do it. If anyone has some code like that they would like to share, it'll be welcome.