>The source of the data is VFP. I don't have anything installed for SQL Server on the server. So, I am looking for information on the minimum requirement to have the SQLClient provider from .NET to respond to SQL commands as well as having the data migrated to SQL Server.

You have to install SQL Server somewhere if you want to use it.

>Presently, when I use the import funtionalities, it creates all the tables with all the data. But, it cannot handle the recognition of my auto incremental keys and the tags. So, I am not sure if that is the best way to do it. Maybe I would need to code it all and issue a migration program.

Is it one time deal?