I want write an win-form applica开发者_运维问答tion to convert data from foxpro table into sql server.when i convert or transfer data in foxpro (with foxpro) my data is transfered very speed.but when i try to convert into sql server ,data is transfered very slow.how can i solve this problem.what technologies can i use? what tips can i use? please help me
You may want to look into SSIS.
In particular, this thread may help.
Did you know that there is a great tool that will mass transfer data from FoxPro straight into SQL Server. If the tables are not already in a DBC, you'll need to make a copy of the entire data set to a new folder, then add those tables to a DBC, then run this SQL Server Upsizing Wizard. Works with SQL Server 2005 and 2008.
http://vfpx.codeplex.com/wikipage?title=Sedna#SQLServerUpsizing
精彩评论