Hi everybody,

I'm interested in the experience of the people who had large multi-user (~60 - 100) project converted from VFP Database to SQL Server database. Can you please tell me what route you take, how much of re-write it was, how long does the project took.

Few more specific questions.

For PK/FK we're using "pseudo" GUIDs (just alphanumerical). Should we use uniqueidentifier field in SQL Server for them?
How can we get new ID after insertion using this type of field?

Also currently each form has BO which are based on one table (using local view). In the Save method there are VFP transactions used and record saved first in the parent, then in children. If anything fails, transactions are rollbacked.

IMO it would make sense to use one SP in SQL Server for all of this process. But how exactly does it work and how can we pass parameters?

Thanks a lot in advance for your input.