Since I'm giving a class on this very subject this weekend at the VFE Devcon I empathize with your observations. My first reaction is that by realizing "It's not as easy as that" you have taken the first very important step.

"Client/Server Applications with Visual Foxpro and SQL Server" from Hentzenwerke can be very helpful. I would suggest first thinking very carefully about the current pk/fk structures in your app and if you are not using guid() as surrogate keys now that is the first conversion I would make, on the vfp side. IMO uniqueidentifiers are the way to go on the SQL side. You can use DTS on the SQL side to move structures and data to your server if you find the upsizing wizard not to your liking.

I wish there were a magic wand for converting veiws to remote views. Biggest thing is understanding differences in syntax.

There are some good tools that can help. Dan Goodwin of Primary Data Solutions has written genviewdbcall.prg which is a more sophisticated version of gendbc. Point it at a dbc of views and it will create a very nice prg for each view. Very nice way to hack the sql. A couple of days ago in preparation for this class I wrote a little prg that looks at all the prgs created by Dan's program and changes them to remote views, fixes some syntax and flags the one that should be eyeballed further. Once the prgs are hacked, you just open your new dbc ( I recommend a new one for the remote veiws ) and run each prg. ( of course you can automate that too )

Dan's stuff is available on his website a primarydatasolutions.com. Send me a message with your email and I'll send you the little hackthings I wrote.


>It's not as easy as that trust me. We have been planning for this upgrade for some time now and have looked at many options. I just wanted to make sure that we had looked at every option possible before going on with the move. Thank you for your reply but if using the upsizing wizard is the only easy option I might as well go out into the wilderness somewhere and end my life as a failed and depressed developer. I am not afraid to use a third party tool or some hidden vfp command but microsoft wizards are far from select your database and hit go and your all your problems will be magically dissapear, otherwise, I would be out of a job. Please ignore my sarcastic attitude and keep the replies coming =)