>I used SQL Server Management Studio 2005 to load several foxpro tables into SQL Server 2005. I need though a program which repeatedly populates SQL Server 2005 tables from Foxpro tables ( not one time conversion). Searching in Google I can't find open source in C# 2.0 which uses certain metadata ( XML or another SQL Server table(s) ) to map tables , fields in a in/out table and types ( if conversion is required ) . Probably it is not a huge task to write anything like that from scratch , but I guess , it is just reinventing the wheel. Ideally it would be nice to an option to create SQL server database from this metadata with indexes , additional identity keys and etc, but just truncating/reloading existing tables will do a job. Has anyone seen such a C# program ?
>I am aware of bcp and coma delimited files from Fox which may be used for loading, but probably it didn't work for memo fields ? Plus not that straightforward : Fox exe to generate csv first , then another exe to load.
>
>TIA
>Michael
Since the data is in VFP... Why not use VFP to load the data into SQL?