>HI
>Has anybody come across a tool that 'Blindly' copies across, and creates, a SQL Server database from a Foxpro database
>Don' t want to have to go into any wizards if possible
>This is something that is required on a nightly run, which takes VFP databses and creates SQL database
>Reason.....The VFP data needs to go to SQL server for use by a third party tool (which only uses SQL)
>
>Not too concerned if a Char field in VFP is transferred into a VarChar field etc, as long as all the data gets transferred
>
>Tia
>Gerard
Gerard, you can create a
SSIS package to do that, but an alternative to this is to create in the sql server a linked server to the foxpro database, then create in sql views to access the foxpro tables and then the third party queries the views, this has the advantage of "live" data, as there would be no need for data transfer between foxpro and sql.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges