🚀 go-pugleaf

Hello All

Im an absolute newbie to Delphi with a VB background. 
Im hoping to quickly learn as much Delphi as I can. 

I have the following scenario. 
I have a legacy Delphi system implemented with BDE and dbf tables. 
(The dbf tables are based on a foxpro backend.)
The dbf tables + data are to be moved into MS SQL Server 2000.
There are about 70 tables with perhaps a few gigs of data in total.
I wanted to know 

1) How to accomplish the move.. Is there an upsize wizard of some sort
and how good is it?
2) How transparent really is the BDE 
3) What would I need to change in the actual Object Pascal code to
implement this migration (still keeping BDE)
4) If I decide to jump ship to ADO :-
 a) are there any performance gains 
 b) how much development effort is required to move from BDE to ADO
 c) If I switch to ADO am I now completely independent of the BDE
(which version of Delphi did this happen)

I thank you all in advance for this vague list of questions.
If you could point me in the right direction I would appreciate it
very much.

Thanks again