Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing Indexes from FoxPro to SQL
- Thread starter apcapc
- Start date
Mike Lewis
Programmer
Andy,
It depends how you do the import. If I remember right, if you use DTS, it will convert the VFP indexes into foreign key contraints. However, this does not happen if you use the VFP upsizing wizard. I recall once having to create the indexes manually after using the upsizing wizard.
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
It depends how you do the import. If I remember right, if you use DTS, it will convert the VFP indexes into foreign key contraints. However, this does not happen if you use the VFP upsizing wizard. I recall once having to create the indexes manually after using the upsizing wizard.
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
Many of the reasons for FoxPro indexes disappear when the data is on SQL server. Once you have the application running with real data you can use the appropriate tools to determine what indexes and what type(s) you need to optimize performance.
Rick
Rick
- Status
