>Hello,
>We are trying to write an application that can modify data structures/tables, data using the same code regardless if the backend if SQL or VFP 7. Our company does not want to have 2 code bases for performing the same functions when trying to modify data.
Access the data via ODBC or ADO for both dbf and SQL Server. Then you just change the connection strings. That's an oversimplification, but you get the idea.
>Also has anyone found an easy way to Backup (and restore if an upgrade fails) on SQL server from within Foxpro.
Using SQL Passthrough or the ADO commmand object, use the T-SQL BACKUP command. It's well documented in the T-SQL docs.
Mike Stewart