Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing fox data
Message
 
 
À
09/03/2010 12:24:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01453503
Message ID:
01453505
Vues:
41
>Hi
>
>I'm importing a large foxpro table into SQL Server.
>
>The import using the Import Export Wizard worked created the table and I have my data but I want to adjust the structure of the table .
>
>When I try to amend the structure I get a warning
>
>Saving Definition Changes to tables with large amounts of data could take a considerable amount of time. While changes are being saved, table data will not be accessible.
>
>How can I import my data into a table which I have already set up so I don't have to change the structure (I'm actually trying to make one of the items a PK.)
>
>Thnaks

Can you insert your data into existing table? Are you using SSIS for this task?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform