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