>Hi,
>
>I have just been handed a project, the nature of this is to upsize some of the main tables of my current database to SQL Server which will involve creating remote views( which I have never done before).
>
>I am a bit lost as to where I should start, is there are good documentation that can get me started?
>
>Any replies would be appreciated.
>
>Cheers
>Mark
Client Server applications by Hertzenwerke is a good starting point!
To get the data into SQL, you can use the VFP upsizing wizard.
To get a remote view of this data create a new database, add it to a project
then under the data tab, you need to create a connection giving it all the details about your SQL server.
You can then create a remote view.
(you will also need an odbc data source setting up in control panel)
HTH
Will
Will Jones