>I am looking for alternative ways to upsize a remote customer's FoxPro database to their SQL Server database. I have it all working locally on my development system but soon I will need to perform the same actions in their real FoxPro and SQL environment. Worst case is to travel to the customer, install FoxPro on one of their systems, and then do the upsize.
>
>I don't know a lot about SQL Server - is there an import within SQL which would do the upsize from that end? Or is their a way to upsize a local copy of their database and then send an image to them to load into SQL?
>
>Thanks,
>Pat

Since you have already created the SQL database on your end, you could send them an "empty" copy of it - one with all the records deleted, but leaving any stored procedures, triggers, etc. needed by the application. They would then "attach" to the empty database from Enterprise Manager or using Query Analyzer. You would then run a routine to send the VFP data into the SQL Server database. This is fairly simple if the data structures are identical. If you need sample code, I can post some. Your client will still have to configure users, security, etc. on that database. They will likely need a SQL Server DBA or plenty of time to figure it out on their own.