Hi Bernard,

I look forwards to the opportunity to exchange ideas of migrating DB to SQLServer. I think I will start a new thread here.

As you can see, I am at the very early stage of the conversion. So any experiences/suggestions will be greatly appreciated.

Thanks


> Hi James

> Unfortunately everyone wants to upgrade their FPW2.6/VFP applications to SQLServer, but want to do it quickly and retain legacy code.

> Yes you can do it, but the whole idea between moving to a C/s solution is not to do what was being done with the old app. With local files the data was all there and was sometimes stored in an array for display.

> With SQLServer this is utterly inefficient. The bottom line in SQLServer -access should be to only get enough data as is essential. Thus if your form has page frames with different data on other pages, you should not get the data till the user activates the page.

> SQLServer is to be used for scalability, not just to update to the latest.

> I really cannot see the justification of using file based technology to access a client server.

> You gotta bite the bullet and make the change. Legacy code brought into a brand new UBeaut application will still be Legacy.

> You gotta balance this legacy code with time and usage and bring the least amount of it into your new app.

> I am currently in the process of "Converting" a legacy FPW2.6 app into VFP* SQLServer. The legacy code even uses pessimistic record locking and with >150 users this is a big hassle. Huge arrays are built and displayed in list boxes( > 30000 records per array)This just wont do in C/S.

> Maybe we could exchange notes?

> I too have developed a framework using CA's since all the current ones used SPT (maybe)

> Cheers

> Bernard