This project is read-only.

SQL Server Upsizing Wizard

Rating:        Based on 6 ratings
Reviewed:  6 reviews
Downloads: 7394
Released: Feb 22, 2017
Updated: Feb 22, 2017 by DougHennig
Dev status: Stable Help Icon

Recommended Download

Source Code
source code, 691K, uploaded Feb 22, 2017 - 7394 downloads

Release Notes

This is an update to the Visual FoxPro 9.0 SP2 Upsizing Wizard. To launch the new wizard run the '' from this location.

Review article on CODE Magazine:

This Sedna update release includes:
  • Updated, cleaner look and feel
  • Streamlined, simpler steps
  • Support for bulk insert to improve performance.
  • Allows you to specify the connection as a DBC, a DSN, one of the existing connections or a new connection string.
  • Fields using names with reserved SQL keywords are now delimited.
  • If lQuiet is set to true when calling the wizard, no UI is displayed. It uses RAISEEVENT() during the progress of the upsizing so the caller can show progress.
  • Performance improvement when upsizing to Microsoft SQL Server 2005.
  • Trims all Character fields being upsized to Varchar.
  • BlankDateValue property available. It specifies that blank dates should be upsized as nulls. (Old behavior was to set them to 01/01/1900).
  • Support for an extension object. This allows developers to hook into every step of the upsizing process and change the behavior. Another way is to subclass the engine.
  • Support for table names with spaces.
  • UpsizingWizard.APP can be started with default settings (via params) for source name and path, target db, and a Boolean indicating if the target database is to be created.

Visit project's home page...

2017.02.22 Release
This update implements better support for BulkXMLLoad by Mike Potjer.

2015.12.01 Release
This update implements a couple of pathing issue fixes by Thierry Nivelet.

2015.09.28 Release
This update fixes several issues found by Matt Slay and Jim Nelson: the Upsizing Wizard didn't properly handle remote table and field names delimited with square brackets, nor did it automatically delimit names using reserved words such as "order". It also didn't handle the rare case where TypeMap.dbf was missing.

2015.08.20 Release
This update fixes another issue found by Jim Nelson: the settings of CURSOSETPROP("FetchMemo"), SET PROCEDURE, and SET PATH weren't restored after running the Upsizing Wizard.

2015.08.18 Release
This update fixes a few bugs found by Jim Nelson: an error when BlankDateValue is set to NULL and NULLDISPLAY is blank, an error when SourceDB is a relative rather than full path, and a warning message when copying files for reporting purposes.

2015.01.13 Release
This update fixes a bug found by Matt Slay that caused the precision (decimals) of numeric fields to be incorrect.

2013.11.25 Release
This update removes the old license and readme files, which are no longer applicable.

2013.11.20 Release
This update fixes a bug, discovered and fixed by Jon Love, that caused a "variable not found" error in the BulkInsert method.

2013.07.24 Release
This update has the following bug fixes (thanks to Mike Potjer for finding and even fixing some of these issues):
  • Upsizing a logical field to a bit field no longer causes an error when the table has a lot of records.
  • You no longer get an error upsizing tables that have field rules, table rules, or triggers.
  • Quotes in the content of fields are preserved.
  • You no longer get a warning that 6.5 compatibility cannot be used.

2013.07.02 Release
This update has the following bug fixes (thanks to Mike Potjer for helping with these issues):
  • Under some conditions, an error occurred while trying to clean up (specifically removing a working directory the wizard created, which may not be empty) after the wizard is done. This code is now wrapped in a TRY to avoid the error.
  • A temporary DBF file wasn't deleted but its FPT was, causing an error if you tried to open it. The file is now deleted.
  • A temporary file used for bulk upload wasn't erased when the wizard is done with it. It is now.
  • One of the export mechanisms ("FastExport") used null dates rather than the defined date for blank VFP date fields. This was fixed.
  • You are no longer told that the bulk insert mechanism failed when it in fact succeeds. This also resolves a problem with duplicate records being created.
  • Under some conditions, the last few records in a VFP table weren't imported into the SQL Server table. This was fixed.

2012.12.06 Release
This update has the following bug fixes:
  • Handles converting Memo to Varchar(Max)
  • You can now change the date used in SQL Server for empty VFP dates in one place: SQLSERVEREMPTYDATEY2K in AllDefs.H
  • One of the export mechanisms ("JimExport") used null dates rather than the defined date for blank VFP date fields. This was fixed.
  • The progress meter now correctly shows the progress of the sending data for each table.
  • A bug that sometimes caused an error sending the last bit of data for a table to SQL Server was fixed.
  • You no longer get a "string too long" error when using bulk insert with a record with more than 30 MB of data.
  • You can now use field names up to 128 characters; the former limit was 30.

Reviews for this release

The Best!!! ThankS ThankS ThankS FoxBearS
by FoxBearS on Dec 11, 2016 at 6:38 PM
Struggled for days to find a way to import VFP files to SQL Server 2005. Standard VFP Upsizing wizard had fatal errors. This is a lifesaver! Great work!
by QuietSeditionist on Jan 29, 2016 at 2:37 PM
This new upsizing wizard is terrific! The CodePlex team done a fantastic job. It worked seemlessly upsizing Visual FoxProx 9.0 databases to MS SQL2012. This is a 5 star solution.
by CarpNewfie on Oct 23, 2013 at 3:44 PM
THANK YOU guys so much for your hard work on this! Yes some of us out here still use VFP and yes some of us are converting data to SQL so this has saved us a bunch of time and headache! Hats off to you!
by kehvn on Sep 3, 2013 at 9:11 PM
It works well, i've tried it for SQL 2005. Thank you
by gruperez on May 6, 2013 at 2:49 PM
I still get some errors (advanced section)
by fonsmoormann on Aug 26, 2010 at 1:56 PM