Migration From Visual Foxpro DBF to Sql Server

[gansindia]

Hi,

I am into Migrating a SBT Vision Point (Accounting System) to Sql Server Enterprise application. We have a system which has accounting module in it. Req is like this i have move the existing data from Visual Foxpro DBF to Sql Server. ( The data structure of our SQL server is different from the existing Vision Point system).

Any pointer of how to go about this .. like any migration tools available or suggestions will be of great help to me..

Thanks
gans

[bharadwajrv]

i hope ur using MS SQL..
i tried this way.. create a DSN for visual fox database...

in sql there is one facility to transfer data from existing to sql..


Start->Programs->Microsoft SQL Server 7.0 -> Import and Export Data..

select source as Microsoft Visual foxpro Driver

next the wizard is self explanatory.. go thug each step careflly... this will transfer the source file into sql along with data..

[gansindia]

thanks
gans