Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simplest way to add one table from VFP to SQL Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00767389
Message ID:
00767781
Vues:
8
Michel,
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.

Hope this helps.

Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform