E-UPSI

Migrating VFP Data to SQL Server

Vortragssprache:Englisch
Vortragstyp: Normal Slot: Day1/Room1/Slot1
Speaker:Daniel LeClair
The VFP Upsizing Wizard is a great way to convert simple VFP databases into MS SQL Server. But what if your needs are more complex? SQL Server offers several ways to port data in and out, but VFP – with its native data engine – can also do the job, if you are prepared to write the code. Which way is best?In this session, we will compare the costs and benefits of using the VFP Upsizing Wizard, SQL’s Data Transformation Service (DTS), and creating your own custom VFP conversion application using SQL Passthrough for bulk-data loading into SQL Server. Attendees will learn about...The VFP Upsizing Wizard SQL BCP and Bulk Insert SQL Data Transformation Services Using custom VFP code for data conversion Applicable To: Visual FoxPro 5 and above, SQL Server 7 and 2000