Three years ago that I work with a VFP database to handle the
administration of a public service company. Currently my data base
consists of a millon of records approximately. As the
database is growing so much in the last months, I decided
to buy Ms SQL Server 7.0 to begin to study it, and thereinafter
upgrade my application.
While I advance with the study, realize me that a lot of "novelties" of SQL7, already exist in VFP and , some Transact SQL commands are equal to VFP (soundex,difference, etc).
Furthermore, the trials that I have accomplished, they are much but slow in SQL that in VFP

The questions are:
It is so complex that it can be implemented by a simple experienced VFP programmer ?
Only is justified the migration for networks with thousands of transactions per minute?
Someone can give me some advice?

Thanks to all