Hi!
No easy way. Indexes on SQl Server are quite different, as well as relations are defined another way. Better re-create them manually using all SQL Server DBA skills. You can get a list of all indexes and relations in database using the GENDBC tool. Create the PRG file for your VFP database. Than examine that PRG file and strip out from it all commands for creating Indexes, PK and relations. This way you will have, at least, the list of all indexes and commands required. You can even try to alter these commands than to make the match the required T-SQL syntax and run them as SQL script to re-create all indexes and relations in SQL database.
HTH.
>In order to connect a remote sales office to the headquarter we thaught about upsizing to SQL server.
>The Upsizing wizzard did well in creating the database on the sql server and putting our data there and it created remote views for all tables.
>Our Problem is that all forms with relations in the dataenviroment don't work anymore and several set order to commands dont work.
>
>Is there any easy way to fix this?
>
>Regards,
>m.Kugler
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.