convert vfp table to sql

[desert227]

I have a table with memo fields, dates etc and want to convert to an sql database. I read somewhere memos had to be changed but don't remember how and same for dates. Is there any sample code around that would show how?

 

[markros]

Do you want to do this from VFP or from SQL Server (if the later, which SQL Server version you're using (64 bit vs 32 bit)?

Take a look at this MSDN thread as how to do this using SSIS for SQL Server 64

http://social.msdn.microsoft.com/Fo...s/thread/c32c0820-0e2d-4461-820a-530541c769c6

PluralSight Learning Library

 

[113983]

Thanks Markros - that looks good - however it is a manual conversion and I am going to create a form to open tables and convert as we have multiple installations. Lots of good tips in that thread.

 

[markros]

If you want to do this from VFP (not from SQL Server) then I suggest to check Doug Hennig blog on SQLXMLBulkInsert.

Let me know if you want me to search for exact link or can find it.

PluralSight Learning Library