Eduardo Fuerte
asked on
Could you point the better strategy on start line insertions obtained in VFP's DBF files into MS-SQLServer then ?
Hi Experts!
I recently obtained here a solution to read data from VFP's DBF files using a C# application.
Now I'm planning to migrate this data to MS-SQLServer.
Could you point the better strategy on doing that?
I don't know if it's a good idea but I started to use VFPToolkit for .Net to complete the task of reading data from DBF and insert then into MS-SQLServer tables.
Thanks in advance.
I recently obtained here a solution to read data from VFP's DBF files using a C# application.
Now I'm planning to migrate this data to MS-SQLServer.
Could you point the better strategy on doing that?
I don't know if it's a good idea but I started to use VFPToolkit for .Net to complete the task of reading data from DBF and insert then into MS-SQLServer tables.
Thanks in advance.
ASKER
Yes, the same way I used when migating to MySQL in a PHP Project in the past.
Just in case, do you consider VFP Toolkit a really a good path for learning .net or it's distocing the natural way of .net programing when mimic VFP?
(it seems it has limited resources mainly in data access by exclusive use of Datatables)
Just in case, do you consider VFP Toolkit a really a good path for learning .net or it's distocing the natural way of .net programing when mimic VFP?
(it seems it has limited resources mainly in data access by exclusive use of Datatables)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the guidance.
I started migration to .net, The technology commonly used in a PHP Project like CSS, Javascript,etc will help me in this task when using Web Pages.
But I have to gradually gain knowledge in C#, so asked about VFP Toolkit.
A WPF Project is going to use MS-SQLServer and exceptionally access DBF files.
I started migration to .net, The technology commonly used in a PHP Project like CSS, Javascript,etc will help me in this task when using Web Pages.
But I have to gradually gain knowledge in C#, so asked about VFP Toolkit.
A WPF Project is going to use MS-SQLServer and exceptionally access DBF files.
ASKER
Thank you for the guidance!
If this should help to learn .NET then do it in .NET
VFP Toolkit is not necessary for this simple data migration you may read the DBF data via VFP OLE DB provider and insert them to SQL Server in a single loop. VFP Toolkit offers functions that mimic features in Visual FoxPro which you don't need for this task.