>Hello All,
>
>I have never used SQL 7.0 either but my office is in the process of converting all our old dbfs (some in 2.6 and some in vfp 5.0) so I'm not so sure of what to do next. I am enrolled in the MSDBA class starting in November and I have some books that have helped me under some of the insides of SQL 7.0. We are discussing what to use as a front end? Do we save much time leaving the front end with the stuff we have now in vf 5.0 as compared to re-writting screens (forms) in vb? If we decide to keep vfp 5.0 as our front end, do you know what are somethings I have to do to the exisitng forms?

You will experience a good learning curve with any front end to SQL Server data. Because you know VFP5 and are not familiar wiht VB I'd stick with VFP and upgrade to VFP6.

How extensive is the app? # of tables and forms?

Working with SQL data is very different from teh same old VFP thing. You have to think about
1) Small data sets
2) Adding a "Find" page to your forms
3) Stored procedcures are now something to investigate
4) Views are good!
5) SQL statements are your friend

Some of the frameworks vendors allow you to keep both local VFP data as well as remote (SQL) data in the same app, and allow you to vary between forms where the data comes from. I use Mere Mortals and it does this fairly well. Look into one of these as a necessary evil.

Are you going to be the DBA or the programmer, becasue in SQL Server they are 2 different positions (in big installs)?


__Stephen