Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying a table to SQL Server
Message
De
26/01/2015 17:21:20
 
 
À
26/01/2015 13:30:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01614306
Message ID:
01614348
Vues:
36
My apologies. My settings were wrong; I did not have any fields selected to be updated. It's all working so far. Thanks very much for your help.

>OK, I think I'm deliciously close.
>
>I used the upsizing wizard and the data is now on the SQL Server.
>
>The upsizing wizard creates remote views.
>
>BUT
>
>1. When I look at the SQL of the remote view I do not see anything that connects it to the SQL Database I linked it to.
>
>2. When update the data, it doesn't update the table in the SQL database.
>
>3. When I look at the remote view, the 'Send SQL Updates' in the Update Criteria tab is DESELECED and grayed out. How do I fix this?
>
>Thanks,
>
>Yossi
>
>>Use the upsizing wizard from VFPX to get the data into SQL Server. http://vfpx.codeplex.com/
>>
>>If you have little experience with SQL Server, go with remote views.
>>
>>>Hi All:
>>>
>>>I have very little experience working with SQL Server databases, but now my client has asked me to copy a bunch of VFP tables to SQL server as part of a program I wrote that he runs every day.
>>>
>>>I have gotten as far as installing SQL Server Express on my local machine, as well as importing the database structure to the SQL Server.
>>>
>>>I wonder is you can point me to some resources that will help me in this quest, as well as answer some questions like should I use views or SPT?
>>>
>>>I appreciate any help.
>>>
>>>Thanks,
>>>
>>>Yossi
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform