Previously, Visual FoxPro’s Upsizing Wizard included nine steps but the Sedna Upsizing Wizard reduces the number of steps to six steps, thereby streamlining the process and placing the steps in a more logical order. The UI uses a standard wizard to step through choices and make appropriate selections for the migration. The Fox Team has revamped and modernized the Sedna Upsizing Wizard user interface (UI). Please note that at the time I’m writing this article, Microsoft has not finalized the features that they’ll include in the final release. I’ve based the changes discussed in this article on the Sedna October 2006 Community Tech Preview (CTP). This article will address each of the steps in the updated wizard, discuss the changes and improvements the Fox Team made to the process, and provide you an example of programmatically controlling the engine along with properties you set and methods you call to perform a database upsizing.
In addition, the entire process is extendible in true VFP tradition.
This means you can skip the user interface and take control of the process so you do not need to re-select your choices again as you step through the user interface each time you want to test a migration. Sedna’s new architecture separates the wizard user interface from the upsizing engine so developers can programmatically control a migration. It has a standard wizard user interface to step you through the process of selecting the appropriate settings to migrate the database structures and optionally the data as one would expect. The first thing you should know about the Sedna Upsizing Wizard is it is more than a standard wizard. I have observed the huge performance improvements the bulk XML insert brings to the process. The Sedna release completely changes the perception and gives you a great tool to migrate data easily to SQL Server 2000 and SQL Server 2005. Sedna attempts to correct all of this and more.įox developers have long mocked the Upsizing Wizard as a weak attempt to assist VFP developers migrating VFP database containers to the SQL Server database platform. The Fox Team listened to the complaints from the Fox Community over the years about the wizard being deficient, with some fatal flaws, and recognized how it became outdated with the advent of SQL Server 2005.
The Sedna Upsizing Wizard is leaps and bounds better than the version previously shipped by Microsoft in any version of Visual FoxPro.
0 kommentar(er)
