BETA Level Release
This initial release has some warts and problems that we wanted to address before releasing a DMW for 4, but I am putting this out there so people can convert basic databases to VistaDB 4 in the meantime. We plan to make several changes to the tool before it is declared complete.
This is a port of the 3.x DMW with almost no changes just to get something up quick. It does not know anything about UAC (you had better run it as Admin), it does not know anything about the Windows 7 Libraries of VistaDB 4, etc. Basic port to get new users up and running.
Data Migration Wizard 4
This is a beta level release. It is posted on the public downloads area of our account manager website. You can’t install or use it unless you have a valid VistaDB license on your machine.
Start Menu Shortcut
Launch the tool from the VistaDB 4 Data Migration Wizard folder in your start menu and you will see the familiar starting screen.
Yes, there is a typo where it still says VistaDB 3 on the initial dialog. It does not work with 3.x at all.
Databases Supported
You can convert SQL Server 2005/2008 databases using SQLClient, SQL CE 3.5 SP1, and Access MDB and ACCDB database formats. Although Access conversion is rough, and does not validate things like views at all (don’t convert them).
Converting a Database from SQL Server
Fill out the connection information like normal, but make sure the VistaDB 4 destination database is a writable location (UAC counts here).
Choose the tables and other information
Select the tables, indexes, foreign keys, etc that you want to bring over to VistaDB.
Convert Away!
Then hit next and watch the window scroll by. Each table schema is created one at a time, including any keys, indexes, etc and then the data is filled in as well.
Saving the scripts
After you complete the migration you can save the scripts to re-run it at anytime in the future. The database should now be loaded and packed. You can also play with the pagesize to see what the minimum is for your database. The DMW just sets it to the max allowed right now.
Click the Open Database to launch Data Builder with the database.
Source Version
The source for the DMW is included with the Professional and higher editions of VistaDB. You can customize and build your own special version from the source as needed.
Lite and Personal users will be able to purchase the Data Migration Wizard and source from the online store for an additional fee.
Subscribe