Click to see larger screenshot of Data Migration Wizard
|
Data Migration Wizard 4
Makes it very easy to migrate existing databases from SQL Server, Microsoft Access
and SQL CE to VistaDB's database format. Full migration of Microsoft's famous Northwind
database takes under a minute. There is a tutorial for
migration of the NorthwindEF Database to VistaDB.
Command Line Scriptable
The DMW is fully scriptable from the command line. You can also redistribute
it with your application to include powerful conversion of existing user databases
to VistaDB automatically.
Source Code Included
The source code to the Data Migration Wizard is included with VistaDB. This allows
you to create and deploy a customized data migration tool for your applications.
|
Features
- Easy-to-use wizard format for quick and easy migration
- Change database settings before migration
- Edit column and table names before migrating
- View the database data and structure before migrating
- Select tables and columns to migrate
- Ability to migrate database schema only without data
- Supports migrating data from:
- Microsoft Access (MDB and ACCDB if Access runtime installed)
- SQL Server 2000/2005/2008 - SQLClient connection to server
- SQL Server Compact Edition (SQL CE) 3.5 (SDF file)
Intent of Migration
The Data Migration Wizard is meant to migrate data, schema, views, and most indexes
(not Full Text or Clustered indexes). If any tables contain user defined types
they will be unable to migrate.
Multiple migrations of the same database will not work. You cannot use the
DMW as a sync tool for data from one database to another, that is not it's intended
purpose. Each migration must create a new database, there is no way to only
accept changes since the last time the database was built.
Check your Views
Views that do not conform to our query parser will also not migrate. The Data
Migration Wizard has a simple test for SQL that it performs, but it is not conclusive
if the query will work or not until after migration. After a migration packing
your database will deep inspect all the views and remove any that do not work against
the actual schema in the database.
Stored Procedures / Functions not migrated
The DMW does not attempt to migrate Stored Procedures or User Defined Functions.
In general most stored procedures will require additional programming work in order
to work with VistaDB. All of our syntax works on SQL Server, but not all theirs
works with us (we are a subset). Things like querying the sys tables, modifying
things through system procedures, etc are not supported in VistaDB.
See the help topic in the manual entitled Stored Procedures for additional guidelines
on migrating your stored procs to VistaDB.
Note
The DMW source included with VistaDB may not be redistributed, but may be recompiled
and distributed with your application for command line migration within your setup
or application.